Returns the rank of a number in a list of numbers, using the average rank for tied values.
構文
RANK.AVG(number, ref, [order])引数
number必須
The number whose rank you want to find.
ref必須
An array of, or a reference to, a list of numbers.
order省略可能
A number specifying how to rank: 0 or omitted for descending, any non-zero value for ascending.
RANK.AVG determines the position of a specific value within a dataset relative to other values. If multiple values share the same rank, the function calculates and returns the average of those ranks.
=RANK.AVG(10, {10, 10, 5, 20})→2.5The number 10 occupies the 2nd and 3rd positions; the average of 2 and 3 is 2.5.
Select the cell
Click the cell where you want the rank to appear.
Enter the formula
Type =RANK.AVG(number, ref) and press Enter.
RANK.EQ returns the top rank for tied values, while RANK.AVG returns the average of the tied ranks.