Randomising names in Excel

New Contributor

I am running a competition and rather than wright and draw the names out physically I would like Excel to randomise them as at the moment they are in alphabetical order.

2 Replies


Let's say you have names in A2:A50.

Select B2:B50.

Enter the formula =RAND() and press Ctrl+Enter to populate all selected cells with the formula.

Click in any cell of B2:B50, then sort ascending. A2:A50 will be affected too, shuffling the names.

Thank you Hans that worked perfectly much appreciated :-))