RANK.EQ
Returns the rank of a number in a list; if more than one value has the same rank, the top rank of that set is returned
Syntax
RANK.EQ(number, ref, [order])
Parameters
- number: Required. The number whose rank you want to find
- ref: Required. An array of, or reference to, a list of numbers
- order: Optional. A number specifying how to rank (0=descending, nonzero=ascending)
Example
=RANK.EQ(5, A1:A10)