How to randomize a list in excel | Excel Random Sort
In this tutorial we’ll learn ways to randomize list in excel this can be used to sort random excel rows, shuffle cells in excel by using the randomize function in excel (a.k.a RAND)
Excel has all sorts of sorting options like ascending, descending, by color and even a custom sort. But it doesn’t have a dedicated sorting option to randomize in excel.
You may need to randomize excel rows to get a list of winners or to create a random list of students to select and much more. Let’s see how you can randomize list in excel.
Randomize List Excel using RAND Function
There is no proper function to randomize excel list but instead there is a function to generate random numbers i.e. RAND(). We have to use this function to achieve this:
Let’s say we have the following dataset containing names of the students and we want to create a randomizer in excel.
- In the adjacent column B, go to cell B2 and type =RAND()
- Drag and copy the formula down. This is generate random numbers for all cells.
- Select all the cells containing the random numbers and under Home tab, go to Sort & Filter and select Sort Largest to Smallest.
- You’ll see a dialog box of Sort Warning. Just select Expand the selection and hit OK.
- Once done, you can see that the names are now in a random sort.
This is the way how to randomize in excel a given list.
Excel Rand is a volatile function, meaning if anything is changed in the worksheet the RAND function will run again and generate new numbers. To prevent the random numbers from calculating again & again just convert the RAND formula to text. You can also just delete the column having RAND formula if your work is done.
You can also you the same steps to randomize multiple columns.
That was all about how to randomize list in excel.
I hope this article was helpful to you and explained you how to use excel sort random, randomize function in excel or build your own randomizer in excel.
If you have any questions or tips, I’d love to hear them in the comment section below.
Free Excel Resources
Get top 10 free excel templates, excel shortcuts and other free excel resources to help you learn excel.
Excel Training Courses
Learn Pivot Tables, Vlookup, Power BI and much more.
Our training courses are coming soon.