RANK.AVG

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.

Sample Usage

RANK.AVG(A10, A1:A100, TRUE)

RANK.AVG(B32, B8:B47, FALSE)

RANK.AVG(A10, A1:A100)

Syntax

RANK.AVG(value, data, [is_ascending])

  • value - The value whose rank will be determined.
  • data - The array or range containing the dataset to consider.
  • is_ascending - [ OPTIONAL - default is descending (FALSE) ] - Whether to consider the values in data in descending or ascending order.

See Also

RANK: Returns the rank of a specified value in a dataset.

RANK.EQ: Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

Was this helpful?
How can we improve it?