Nifty Office Features: =RAND()

Need to randomize a list, such as your class roster to assign groups? Use excel and the =RAND() formula!

  1. Add the list of names to one column.
  2. In the first cell of the next column, add the forumla =RAND().
  3. Copy the formula down the column. (Double-click the fill handle.)
  4. Each name now has a random number.
  5. 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.