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!
3 Replies
- I totally get your frustration when it comes to figuring out randomization in Excel. While my response might be a bit late for you, it could still help others who stumble upon this post. To select a random name from a list in Microsoft 365 Excel, you can use a combination of functions. One way is to use the RAND function to generate a random number for each name in your list and then use the INDEX function to pick the name associated with the highest or lowest random number. But hey, if you're looking for a quick and fun solution, I recently found a cool online tool called FlipSimu (https://flipsimu.com/dice-roller/roll-d4/). It has a nifty d4 roller that can give you a random outcome with just a click. You can customize the number of sides and even roll multiple dice for more excitement.
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!
