Randomly Sort a List in Excel

At work I often graph individual physician statistics against each other but want to do this anonymously. To do this, I sort my source data randomly.

Be sure to subscribe to the newsletter for more Excel tips and tricks.

This is a nice trick that takes advantage of the RAND function in Excel. RAND will give you a random number between 0 and 1. Drop this function down next to your list of data. Then a simple sort (ascending or descending — remember, this is random) will sort the data in order of these random numbers.