Forum Discussion
Solved
need to get a random number for each different names on my spreadsheet (same name can appear twice)
Hello, I am looking for a bit of help here as i am still learning my way into excel. I have this list of people that i need to transform into random numbers for anonymization reasons. i thought of...
Hello! You can use this:
=HSTACK(UNIQUE(B3:B11),INDEX(UNIQUE(RANDARRAY(ROWS(UNIQUE(B3:B11)),1,0,1000000,TRUE)),SEQUENCE(ROWS(UNIQUE(B3:B11)),1)))
Change range B3:B11 with the actual range of your names. It will create an array with all unique names with a random integer number next to each one.
Hi, I edited my reply, please refer again to it. Additionally, your error seems to be because you may use Excel in another language. Please try to translate all functions to your language and change the comma separator to ";" if needed.
thank you for your help !