What's the simplest way to make a genuinely random name selection system using Microsoft tools?

Question

For example, suppose I have a list of participants in Excel and want to randomly select one winner without manually choosing from the list.

Would you use RAND/RANDBETWEEN in Excel, Power Automate, or another Microsoft 365 approach? I'm also interested in preventing the same person from being selected twice when several winners are needed.

I'd appreciate an approach that's easy for someone without much Excel or Power Automate experience to understand.

riny_van_eekelen · Answer

AbdulWaheed3​ I would just add a column to your list of names with =RAND(). This assigns a random number for each person. Press F9 to re-assign random numbers and then sort the list by number (ascending or descending). The first name(s) on the list is(are) your winner(s).&nbsp;

Forum Discussion

What's the simplest way to make a genuinely random name selection system using Microsoft tools?

1 Reply