• Excel Book Excerpt

Excel Randomly Sequence a List

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Randomly Sequence a List

Problem: The students in my class must present an oral book report. Rather than have them go alphabetically, I want to randomly sequence them. How can Excel help me do that?

Strategy: Put the students in column A. Add a =RAND() formula in column B. Sort by column B. Each time that you sort, the students will be in a different sequence.


Figure 475 Sort by the RAND() column.

Gotcha: The data is sorted, and then column B is recalculated. It will appear that the new figures in column B are not in any order. This is because the sort was based on the previous values in column B.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: