If there is a list of items, names, or numbers, you can randomize the list using simple Excel formulas. Although there is no native function in Excel to perform random sorting, there is one to produce random numbers.
Method 1:
Step 1: Take a list of Name.
Step 2: Copy the Same Name in a new column called Shuffled Name
Step 3: In the next step generate random number through RAND Function in the Random Number column.
In cell D2 write RAND() and hit enter, after that copy the cell D2 and paste through D3:D11.
Step 4: Click on cell D2, then follow the steps: Data >> Sort >> Sort by >> Random Number >> OK
Name shuffled in Column C. Result outlined below:
If you want to shuffle more the same name, then Press F9 to change the Random number and sort column C.
Method 2:
We use SORTBY Function along with RANDARRY and COUNTA function to shuffle the name column.
Step 1: Click on cell B2, then put the formula there.
The formula will be:
=SORTBY(A2:A11,RANDARRAY(COUNTA(A2:A11)))
Step 2: Press the Enter.
The logic is we sort names by SORTBY function by incorporating random number through RANDARRAY function and counting text in the list through COUNTA function.
Result outlined below:
Press F9 to change the random number in RANDARRAY function. In each time you press F9 name will be shuffled in Column B.
You may be interested: