Forum Discussion
Randomising names in Excel
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.
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 :-))
