MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Alex on September 17, 2001 7:47 PM

What is the easiest way to look at a list of times and determine which is the quickest, and place 1 in an adjacent column, then next quickest and place 2 etc etc.

Is there an easy was of doing this without macros etc.


Posted by Jaime on September 17, 2001 8:12 PM

Use the rank function.