RANK_AVG(arg1, arg2, arg3) → { number }

Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.


Name Type Description
arg1 number

The number for which the rank will be returned.

arg2 Array.<number> | ApiRange

An array of numbers or a reference to a list of numbers. Nonnumeric values are ignored.

arg3 boolean

The numeric value that specifyes how to order the numbers. If it is 0 or omitted, the rank in the list will be sorted in descending order. Any other numeric value means that the rank in the list will be sorted in ascending order.