RANKEQ
Description
Returns the rank of a number in a list of numbers. Similar to RANKAVG() but if there are duplicate instances of the number to be ranked, RANKEQ() returns the lower rank.
Syntax
RANKEQ(
number
,
ref
, [
order
])
- number: The number to determine the rank for.
- ref: The list of numbers to use in determining the rank.
- order: The sort order. 0 (the default) = descending; 1 = ascending.