Forum Discussion
Randomizer
I'm trying to select a random name from a list in Excel but I cannot figure out how to do it in Microsoft 365. HELP! Need it ASAP!
Let's say your list is in A2:A50, i.e. it contains 49 names.
The formula =INDEX(A2:A50,RANDBETWEEN(1,49)) will return a random name from the list.
Each time Excel recalculates formulas a new name will be returned.
- You are AWESOME!! Thank you so much! I couldn't for the life of me remember that formula!
