Oct 09 2022 03:24 AM
Oct 09 2022 03:59 AM
Let's say you have names in A2:A50.
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.