Author: Oscar Cronquist Article last updated on May 02, 2018

The RANK.AVG function returns the rank of a number in a list of numbers.

The number returned indicates its size relative to other values in the list. If more than one value share the same rank, the average rank is returned.

Formula in cell E3:

=RANK.AVG(77,B3:B11,0)

Excel Function Syntax

RANK.AVG(number, ref, [order])

Arguments

number  Required. The number whose rank you want to find.
ref Required. A list of numbers.
[order] Optional. A number specifying how to rank number.
0 - Excel ranks number as if ref were a list sorted in descending order. Default value.
Any other number - Ascending order.

Comments

Nonnumeric values in Ref are ignored.