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

Hello AbdulWaheed3​,

For a simple Excel-only solution, I would use RAND() if the list is intended to be easy for beginners to understand.

If the names are in A2:A21, add a random-number column:

=RAND()

Then sort the table by that column. The first 3 rows would be three different winners, so the same person cannot be selected twice in that draw.

If you're using Microsoft 365, you can also do it without a helper column:

=TAKE(SORTBY(A2:A21,RANDARRAY(ROWS(A2:A21))),3)

This returns 3 randomly ordered names from the list, without duplicates.

The main thing to remember is that RAND() recalculates, so the result can change when Excel recalculates the workbook. If the winners need to remain fixed, copy the resulting names and paste them as values after the draw.