How to randomize a list of names in excel without duplicates

Often you may want to randomly shuffle rows in Excel:

Fortunately this is easy to do by using the RAND() function to create a helper column with random numbers for each row and then by sorting on the helper column.

The following step-by-step example shows how to shuffle rows in Excel in practice.

Step 1: Enter the Dataset

First, let’s create the following dataset that contains information about various basketball players:

Step 2: Use RAND() to Create Helper Column

Next, type the following formula into cell D2 to generate a random value between 0 and 1:

We can then click and drag this formula down to each remaining cell in column D:

Step 3: Shuffle the Rows

We can now “shuffle” the rows in the dataset by sorting the rows based on the values in the Random Value column.

To do so, highlight the cell range A2:D11, then click the Sort icon within the Sort & Filter group in the Data tab along the top ribbon:

In the new Sort window that appears, choose Random Value in the Sort by dropdown menu:

Once you c

how to reorder rows in excel based on one column

how to reorder rows in excel pivot table