Categories: Uncategorized

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.

Joshua Aaron jones

A thinker and tinkerer of law and public policy. What shall we discuss?

Share
Published by
Joshua Aaron jones

Recent Posts

Rhetorical Histoy Timeline

Interactive Timeline of Rhetorical History 8th Century BCE – Epic Poetry Rhetoric had not yet…

10 hours ago

MPT Builder Template

Here is a template to build your very own Multi-State Performance "style" exam. After you've…

4 weeks ago

Word Count Restraint Syndrome

Oh, Claude! § § § Three students unable to express their Contracts analysis in fewer…

4 weeks ago

AI Law Final Spring 2026

AI Law Final Spring 2026 — Administrative Process: AI in Law and Practice ⚖ Administrative…

4 weeks ago

Solution Vibing: An Adobe Acrobat Word Counter

I want my students to have experience with Adobe Acrobat and pdfs before their first…

1 month ago

Oh, Blog. I remember you.

As so often happens in the land of academia, I've been so busy with teaching,…

8 months ago