Forum Discussion
Unique values based on distinct values in a column
I have a problem where I need to generate a unique value for each unique value in a column. The column has throusands of rows and hundreds of unique values.
EG
| Column A (text) | Desired column |
| value a | UNIQUE 1 |
| value b | UNIQUE 2 |
| value c | UNIQUE 3 |
| value c | UNIQUE 3 |
| value d | UNIQUE 4 |
| value a etc.... | UNIQUE 1 |
I stress again there are two many values to manually assign a unique value.
Any help really appreciated. Totally stuck.
1 Reply
Hi chakrared ,
Please check this article which enables you to group similar values and generate an index using Power Query.
https://www.howtoexcel.org/power-query/grouped-serial-numbers-with-power-query/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
