Excel random selection from list
- random sort in excel
- random shuffle in excel
- random sort names in excel
- random sort rows in excel
How to randomize a column in excel!
How to Randomly Sort a List in Excel
August 15, 2017
Have you ever needed to take a list and randomly sort it?
How to randomize a list of names in excel without duplicates
How would you do it? It’s not as intuitive as you think. We’re so used to sorting lists in alphabetical order or from smallest to largest, but this idea of randomly sorting a list is not very common in Excel. Let’s jump right into it and show you how to randomly sort a list in Excel.
Sample Data
Say we have some data that we’d like to sort:
Normally, we could sort by Movie title, the date that it opened (as it’s shown in the picture), or by the total amount it grossed.
But what if we wanted to “shuffle” this list? How could we go about doing that?
By the way, this is the same data that we used in the Sum the Top 5 Values post.
You can also copy and paste this table to follow along:
| Movie | Date Opened | Total Gross |
|---|---|---|
| Deadpool | 2/12/16 | $363,070,709 |
| Zootopia | 3/4/16 | $341,268,248 |
| Batman v Superman: Dawn of Justice | 3/25/16 | $330,360,194 |
| The Jungle Book (2016) | 4/15/16 | $364,001,123 |
| Captain America: Civil War | 5/6/16 | $408,084,349 |
Finding Dory
|