Formulas and Functions

Table Of Contents

Â largest-is-high: An optional value specifying whether the smallest or the largest

value in the collection is ranked 1.

largest is low (0, FALSE, or omitted): Assign the largest value in the collection the

rank 1.

largest is high (1, or TRUE): Assign the smallest value in the collection the rank 1.

Usage Notes

Values included in the collection that are the same are ranked together, but impact Â

the outcome.

If the specied value does not match any of the values in the collection, an error is Â

returned.

Examples

Assume the following table contains the cumulative test scores for this semester for your 20 students.

(We have organized the data this way for the example; it would likely originally have been in 20

separate rows.)

=RANK(30, A1:E4, 1) returns 1, as 30 is the smallest cumulative test score and we chose to rank the

smallest rst.

=RANK(92, A1:E4, 0) returns 2, as 92 is the second-largest cumulative test score and we chose to rank

largest rst.

=RANK(91, A1:E4, 1) returns 4, as there is a “tie” for second place. The order is 100, 92, 92, then 91 and

the rank is 1, 2, 2, and then 4.