RANK.AVG
Returns the rank of a number in a list; if more than one value has the same rank, the average rank is returned
Syntax
RANK.AVG(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.AVG(5, A1:A10)