RANK()
Returns the rank of a number within a list — 1st, 2nd, 3rd, and so on.
RANK(number, ref, [order])RANK compares number against every value in ref and returns its position when the list is sorted — largest first by default. Ties share the same rank, and the next rank after a tie is skipped.
Set order to any nonzero value to rank ascending instead, where the smallest number is rank 1.
Modern Excel offers RANK.EQ (identical behavior) and RANK.AVG (averages tied ranks instead of skipping); RANK itself is kept only for compatibility with older files.
Arguments
- number
- The value to find the rank of.
- ref
- The list of numbers to rank against.
- orderoptional
- 0 or omitted for descending (largest = 1); any nonzero value for ascending.
Examples
=RANK(B2, B:B)→1 (North ranks highest)
B2 is the largest value in column B, so it ranks 1st.
=RANK(B2, B$2:B$20, 1)→4
Ranking ascending — the smallest value would be 1.