Rank race results

Generic formula
=RANK(time,times,1)
Summary
To rank a set of race times, where the lowest (fastest) time is ranked #1, you can use the RANK function. In the example shown, the formula in D6 is:
=RANK(C6,times,1)
Where times is the named range C6:C13.
Explanation
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)
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.