All functions / Statistics
RANK
The position of a number in a list (1 = largest by default).
Syntax
=RANK(number, ref, [order])
Arguments
number: The value to rank.ref: The list of numbers.order(optional): 0 or omitted = descending, 1 = ascending.
Example
=RANK(B2, $B$2:$B$10) → 1 for the top score
Also written as RANK.EQ.