How to pick a random name in Excel
By the Spinrin editorial team. Updated .
Copy-paste Excel formulas to pick one random name or several winners with no repeats, plus how to stop the result from changing.
Put your names in one column, for example A2:A31, with no blank rows. Then use one of the formulas below in any empty cell.
Pick one random name (any Excel version)
=INDEX(A2:A31, RANDBETWEEN(1, ROWS(A2:A31)))
RANDBETWEEN picks a row number, and INDEX returns the name in that row. Every name has the same chance.
Pick several winners with no repeats (Excel 365 and Excel 2021+)
=TAKE(SORTBY(A2:A31, RANDARRAY(ROWS(A2:A31))), 3)
This shuffles the whole list and keeps the first 3 names. Change 3 to the number of winners you need. In Excel 2021, which has no TAKE, use =INDEX(SORTBY(A2:A31, RANDARRAY(ROWS(A2:A31))), SEQUENCE(3)).
Stop the result from changing
Random functions recalculate every time the sheet changes, so the winner will change too. Right after the draw, copy the result cell and use Paste Special > Values. Press F9 if you want to draw again before freezing it.
Is Excel random enough?
For a classroom or a team lunch, yes. For a prize draw where people may question the result, a spreadsheet is hard to prove: anyone can press F9 until they like the answer. A certified draw publishes a code before the draw and a certificate after it, so entrants can check the winner themselves.
Faster option
Paste the same column into the random name picker and spin. It handles duplicates, multiple winners and elimination with one click.