How to Shuffle a List of Items/Names in Excel?

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.

Shuffle Item

Step 2: Copy the Same Name in a new column called Shuffled Name

Shuffle Item

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.

Shuffle Item

Step 4: Click on cell D2, then follow the steps: Data >> Sort >> Sort by >> Random Number >> OK

Shuffle Item

Name shuffled in Column C. Result outlined below:

Shuffle Item

If you want to shuffle more the same name, then Press F9 to change the Random number and sort column C.

Shuffle Item

Method 2:

Shuffle Item

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)))

Shuffle Item

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:

Shuffle Item

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:

  1. Financial Dashboards
  2. Sales Dashboards
  3. HR Dashboards

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories