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