Tom’s Tutorials For Excel: Ranking a List in Random Order
Here’s an example of setting up your worksheet to randomly rank a list of items. In this first set of pictures, the list of names is randomly ranked three times, simply by hitting the
F2 key on any cell in the worksheet, and pressing
In the next pair of side-by-side screen shots, Step 1 is to enter the
RAND() function into the cells of a helper column. In Step 2, the formula for the ranking column,
=RANK(B3,$B$3:$B$12), is entered into cell C3 and copied down to cell C12.