You can do this too
Download “The one essential add-in for all Excel users.'”
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
Language:
Range » Sort the data in random order
This utility sorts your selected range in a random order from top to bottom.You can for example use this to randomly sort your list to pick 5 lottery winners.
Another example is to make sure that the start of the competitors in a contest is in random order.
Screenshots
Example screenshot: Sort in random order
Starting this utility
In the Excel menu choose: ASAP Utilities » Range » Sort the data in random order« Return to the list of “Range” tools.
| « Previous Advanced sorting... | Next » Flip selected cells |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utitilities
Additional keywords for this tool:
Randomise, change order, random order, Sort rows random (shuffle), randomize
Randomise, change order, random order, Sort rows random (shuffle), randomize
Follow ASAP Utilities on Facebook
© 1999-2013 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands 
Connect with us and receive our "tip of the week" at:
