RANK
Returns the rank of a number in a list of numbers. Replaced by RANK.EQ.
Syntax
RANK(number, ref, [order])
Parameters
- number: Required. The number whose rank you want to find
- ref: Required. An array of, or a reference to, a list of numbers
- order: Optional. A number specifying how to rank: 0 or omitted = descending, nonzero = ascending
Example
=RANK(5, A1:A10, 0)