RANK.EQ
Description
Returns the rank of a number in a list of numbers. Similar to RANK.AVG() but if there are duplicate instances of the number to be ranked, RANK.EQ() returns the lower rank.
Syntax
RANK.EQ(
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.