Forum Discussion
mstaples929
Apr 02, 2021Copper Contributor
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!
dominicyberx
May 31, 2023Copper Contributor
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.