RANK_AVG

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.

Parameters:

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.

Returns:

Type
number