Forum Discussion

mclarke's avatar
mclarke
New Member
4 years ago
Solved

Assign to each unique value a number

Hi guys, I'm trying to assign a numerical code (consecutive ideally but not necessarily) for each unique value from a column. Is there a way to do this?   I hope you can help me!!
  • ribisht17's avatar
    ribisht17
    4 years ago

    mclarke 

     

    Like this ?

     

    Please use this >>> 

    RANKXC = RANKX(Sheet4,Sheet4[Category],(Sheet4[Category]))
     
    Regards,
    Ritesh