RANK.AVG Function - Ranking a Number in an Excel Number List

Buzz

Ngày cập nhật gần nhất: 15/4/2026

This article below introduces you to the RANK.AVG function - one of the functions in the statistical group widely used in Excel.

Description: The function returns the rank of a number in a list of numbers, considering the size of the number relative to other values. If multiple values share the same rank, the function returns the average rank. Supported in Excel since 2010.

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

In detail:

- number: The value you want to find the rank of, which is a required parameter.

- ref: An array or reference to a list of numbers, which is a required parameter.

- order: A number indicating how the ranks are sorted, which is an optional parameter.

Note:

- If order is omitted -> the function defaults to ranking the ranks in descending order.

- If order ≠ 0 -> the function defaults to ranking the ranks in ascending order.

Example:

Determine the ranking of the value 66 in the data array described below:

- Determine the ranking of the value 66 in descending order. In the cell where you want to calculate, enter the formula: =RANK.AVG(D6,D7:J7,D8)

- Press Enter -> the ranking of the value 66 is:

- Determine the ranking of the value 66 in ascending order. In the cell where you want to calculate, enter the formula: =RANK.AVG(D6,D7:J7,D8) -> Press Enter -> the returned value is:

So with 2 different sorting methods -> the rank of the same value differs.

So with the value order ≠ 0-> the array is sorted in ascending order.

- In case of 2 identical values having the same rank -> the function returns the average rank:

Above is the guide and some specific examples of using the RANK.AVG function in Excel.

Wishing you all success!

Frequently Asked Questions

How does the RANK.AVG function work in Excel?

The RANK.AVG function in Excel returns the rank of a specified number within a list. It calculates the rank considering the size of the number relative to other values, and if there are ties, it provides the average rank for those values.

What parameters are required for using the RANK.AVG function?

The RANK.AVG function requires two parameters: 'number,' which is the value you want to rank, and 'ref,' which is an array or reference to a list of numbers. The optional 'order' parameter determines whether ranks are sorted in ascending or descending order.

Is it possible to get the average rank for tied values with RANK.AVG?

Yes, it is possible to get the average rank for tied values using the RANK.AVG function. When multiple values share the same rank, the function automatically calculates and returns their average rank, ensuring accurate representation of tied rankings.

What happens if the order parameter is omitted in RANK.AVG function?

If the order parameter is omitted in the RANK.AVG function, it defaults to sorting ranks in descending order. This means that higher numbers receive a lower rank, while lower numbers receive a higher rank in the ranking process.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]