Using the Excel RANK.AVG Function


The Excel RANK.AVG function returns the rank of a number in a list of numbers. Rank is determined by a number's size relative to other values in a set. If more than one value has the same rank, the average rank is returned.

RANK.AVG, along with RANK.EQ, have replaced the RANK function. RANK is still available as a compatibility function.


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

Syntax Breakdown

Required. The number whose rank you wish to find.

Required. Array, or reference to, a list of numbers. Non-numeric values are ignored.

Optional. How you want to rank the numbers. The options include:

0 (zero) or omitted, the function ranks number as if ref was sorted in descending order.

Any non-zero number, the function ranks number as if ref was sorted in ascending order.

Usage Notes

RANK.AVG returns the rank of a number when compared to other numbers in a list. If the number argument contains duplicate values, the function returns an average rank to the set of duplicates.

It isn't necessary to sort the values prior to using RANK.AVG.

To assign the same value to duplicate values, use the RANK.EQ function.