How to pick a random name in Google Sheets
By the Spinrin editorial team. Updated .
Three ways to pick random names in Google Sheets: a one-cell formula, a shuffled list for several winners and the built-in Randomize range.
Put the names in column A starting at A2. The formulas below adapt to the length of your list.
1. One random name
=INDEX(A2:A, RANDBETWEEN(1, COUNTA(A2:A)))
2. Several winners with no repeats
=ARRAY_CONSTRAIN(SORT(FILTER(A2:A, A2:A<>""), RANDARRAY(COUNTA(A2:A)), TRUE), 3, 1)
This shuffles the non-empty names and keeps the first 3. Change the 3 to the number of winners.
3. Shuffle the list in place
Select the names, right-click and choose Randomize range. The order changes once and stays put, which makes it easy to read the first names as winners.
Freeze the result
Formulas recalculate on every edit. To keep a result, copy it and paste with Ctrl+Shift+V (Cmd+Shift+V on Mac) to paste values only.
When a spreadsheet is not enough
If entrants will question the result, use a certified draw. It publishes a commitment code first and a certificate after, so anyone can confirm the winner was not chosen by hand. For quick everyday picks, paste the column into the random name picker.