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

Graphics, Graphics, Graphics

It's really fun to revisit old graphics and have AI rework them. What a time…

2 weeks ago

All About Connecticut

This academic year, I am a Visiting Associate Clinical Professor at the University of Connecticut…

3 weeks ago

AI Isn’t Slowing Down. Neither Are the Questions Around It.

Each year, Stanford's Institute for Human-Centered Artificial Intelligence (HAI) releases its AI Index report. The…

5 months ago

Rhetorical Histoy Timeline

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

5 months ago

MPT Builder Template

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

5 months ago

Word Count Restraint Syndrome

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

5 months ago