KUstudent
New Member
- Joined
- Jan 18, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- MacOS
Hey, guys! Happy New Years! I was hoping I could get some help. I have roughly 3,000 usernames in column B, and I need to assign each one a random string of letters and/or numbers.
I know about =RANDBETWEEEN(, but some of the usernames repeat, and I need repeat usernames to be assigned the same random string of letters. (Essentially, to protect the participants anonymity, I'm creating ID#s for them.)
Is there a function or macro that could do this for me so that I don't have to do all three thousand by hand? Thank you in advance!
I know about =RANDBETWEEEN(, but some of the usernames repeat, and I need repeat usernames to be assigned the same random string of letters. (Essentially, to protect the participants anonymity, I'm creating ID#s for them.)
Is there a function or macro that could do this for me so that I don't have to do all three thousand by hand? Thank you in advance!