# How To Randomize A List In Excel

### As you can see in the screenshot below this formula actually sorts numbers from 1 to 5 in random order.

How to randomize a list in excel. Creating the Randomized List Open up the spreadsheet you want to randomize. How to Sum if Date is Greater Than A Date in Excel. Head over to the Ablebits Tools tab Utilities group click the Randomize button and then click Shuffle Cells.

Then enter the formula RANDBETWEEN 1100. Select the cell with the random sample number. Each cell in this column will return a random number which will help sorting numbers and select consecutively from that order.

7 Hold down Control and tap C. To start enter the RAND syntax into the cell beside the first entry of our list. We have to use this function to achieve this.

INDEX function will return the value corresponding to the returned number in the first column as list has only one column. Where n is the number of random values you want to get. ROWS table returns the number of rows in the table which will be the last index of value in the list which is 12.

Generate list random numbers2. Generate list random numbers2. Select a blank cell that will place the random value type this formula INDEX A2A16 RANDBETWEEN 2 16 then press Enter key.

Next we need a way to randomly sort the list. SORTBYSEQUENCE5 RANDARRAY5 Enter the formula in the topmost cell press the Enter key and the results will spill automatically over the specified number of cells. Doing this will copy the RAND command.