RANK.AVG
The RANK.AVG function assigns the rank of a specified value in a list of values, with tiebreakers handled by averaging the ranks.
Syntax 🔗
=RANK.AVG(number, ref, [order])
number | The value you want to rank. |
ref | An array of values representing the list of values to rank against. |
order (Optional) | A numerical value specifying the ranking order. 0 (descending) is the default, 1 (ascending) for smaller values being ranked higher. |
About RANK.AVG 🔗
Need to assess where a number stands within a range of values? Look no further than the RANK.AVG function in Excel. This efficient tool effortlessly assigns a rank to a specified value among a list of values, with any tie scenarios resolved by averaging the ranks assigned to the tied values. Ideal for scenarios requiring a reliable mechanism for ranking, such as academic performance evaluations or sales performance assessments, RANK.AVG proves to be a valuable asset in your Excel toolkit. Simply provide the value you aim to rank, along with the reference array of values to compare against, and if needed, specify the ranking order to adjust the sorting behavior. Let RANK.AVG simplify your ranking tasks with precision and convenience.
Examples 🔗
Consider an array of test scores: 85, 78, 92, 85, 78. You want to know the rank of a new score of 85 within this set. The RANK.AVG formula would be: =RANK.AVG(85, {85, 78, 92, 85, 78})
Assume you have sales figures for a sales team: $1500, $1900, $1500, $1200. You wish to rank a new sales figure of $1600 within this dataset. The RANK.AVG formula would be: =RANK.AVG(1600, {1500, 1900, 1500, 1200}, 1)
Notes 🔗
Make sure the values in the reference array are in the same format and unit as the number being ranked. The optional 'order' argument allows you to control whether higher or lower values receive higher ranks. By default, duplicate values will receive the same rank, with the ranks of the tied values averaged.
Questions 🔗
In cases where there are tied values in the reference array being ranked, RANK.AVG resolves ties by assigning the average of the ranks that would have been occupied by those values. This ensures a smooth and equitable ranking process.
Can I change the default ranking order in the RANK.AVG function?Yes, you can alter the ranking order by specifying the optional order argument. Use 0 for a descending order where higher values receive higher ranks, and 1 for an ascending order where lower values receive higher ranks.
No, the RANK.AVG function can handle duplicate values in the reference array. If multiple values are tied, their ranks will be averaged and assigned accordingly.
How accurate are the ranks provided by the RANK.AVG function when handling tiebreakers?The RANK.AVG function maintains high accuracy when dealing with tiebreakers by ensuring that the final rank assigned to tied values is the precise average of the ranks they would have held individually.