Excel Rank race results Example
This tutorials shows how to Rank race results in Excel.
To rank a set of race times, where the lowest (fastest) time is ranked #1, you can use the RANK function.
Formula
=RANK(time,times,1)
Explanation
In the example shown, the formula in D6 is:
=RANK(C6,times,1)
Where times is the named range C6:C13.
How this formula works
You can use the RANK function to rank numeric values. RANK has two modes of operation: ranking values so that the largest value is ranked #1 (order = 0), and ranking values so that the smallest value is #1 (order = 1).
In this case, we are ranking race times. The lowest/fastest value should rank #1, so we set the order argument to 1:
=RANK(C6,times,1)