How to randomize a list in excel into groups

This article teaches you how to randomize (shuffle) a list in Excel. For example, let's randomize the list in column A below.

1.

Randomize list of names

How to shuffle data in excel

How to randomize a column in excel

List of random names in excel download

How to randomize a list of names in excel without duplicates

Select cell B1 and insert the RAND() function.

2. Click on the lower right corner of cell B1 and drag it down to cell B8.

3. Click any number in the list in column B.

4. To sort in descending order, on the Data tab, in the Sort & Filter group, click ZA.

Result: a random list in column A (sorted on the random numbers above).

Note: random numbers change every time a cell on the sheet is calculated.

If you don't want this, simply copy the random numbers and paste them as values.

If you have Excel 365 or Excel 2021, use RANDARRAY, SORTBY and ROWS to randomize a list in Excel.

How to shuffle cells in excel 2016

The following formula is pretty awesome.

5. First, use the RANDARRAY function to generate a list of random decimal numbers between 0 and 1. The array below consists of 8 rows and 1 column.

Note: the RANDARRAY function, entered into cell B1, fills multiple cells.

Wow! This behavior in Excel 365/2021 is called spilling.

6. The SORTBY functi

how to shuffle names for secret santa in excel

how to randomize names into groups in excel