Oct 09 2022 03:24 AM
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.
Oct 09 2022 03:59 AM
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.
Oct 09 2022 04:05 AM