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 using ALEA but i have another problem, the same person can appear more than once on my list. if they appear twice, i still need them to have the same random number. I do not know how to do that, can someone help me please ?
thank you 🙂
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 using ALEA but i have another problem, the same person can appear more than once on my list. if they appear twice, i still need them to have the same random number. I do not know how to do that, can someone help me please ? thank you 🙂 Read More