MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Placings


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.

Thanks


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

Use the rank function.