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