Need to randomize a list, such as your class roster to assign groups? Use excel and the =RAND() formula!
- Add the list of names to one column.
- In the first cell of the next column, add the forumla =RAND().
- Copy the formula down the column. (Double-click the fill handle.)
- Each name now has a random number.
- Sort the column with numbers. It doesn’t really matter whether you do it by largest or smallest number.




And VOILA! Your list of names are now sorted randomly.
Discover more from JAJONES | jurist
Subscribe to get the latest posts sent to your email.