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.