Rank race results

Rank race results

Generic formula 

=RANK(time,times,1)

Related formulas 

Rank function example

Explanation

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.

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)

Rank race results

Generic formula 

=RANK(time,times,1)

Related formulas 

Rank function example

Explanation

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.

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)