RANK
Returns the rank of a number in a list of numbers.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Returns rank of number in list (Legacy).
Syntax
RANK(number, ref, [order])
Arguments
number(number) — Value.ref(range) — List.order(number) — 0=Descending, 1=Ascending.
Examples
Legacy Rank
Rank of 10.
FORMULA
=RANK(10, A1:A5)
RESULT
1
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 10 |
| 3 | 5 |
| 4 | 2 |