RANK.AVG Function in Excel

RANK.AVG works in the same manner as a simple Rank function. It returns the rank of defined values of a given dataset, but if duplicate or same value lies within the dataset then the RANK.AVG function will assign an average rank to each set of duplicates. Keep in mind, RANK.AVG function only consider numeric values and ignore other values (texts, date and so on)

If you are not familiar with the Rank function of Excel till now, then please follow this tutorial first for getting the concept.

URL: https://www.tutorialabc.com/2020/06/working-with-rank-function-in-excel.html

Basic Syntax

= RANK(number, ref, [order])

Where, ‘number’ is the value whose rank will be determined. Then ‘ref’ is the array or range containing the dataset to consider and finally, ‘order’ is the last argument but it is optional. This argument will help you to maintain the order of the list and rank them according to descending or ascending order.

•      0 or leave the argument empty: It will rank the list in default descending order.
•   1: for ascending order please type 1 in the last argument field of the rank function.

Example

Suppose, you have a worksheet which contains data like the below screenshot and you can see that, this worksheet contains a duplicate value. 

(Sample data)

So, in this sort of case, we can rank those values by using Rank.Avg function. Here, we are adding a GIF file which includes all the steps required to complete the full process. Please take a good look at the GIF and hopefully, you will get a clear understanding of Rank.Avg function. 

(Complete Process in a GIF)

Thanks for staying with tutorialabc.com! If you have any queries, please feel free to knock us via our contact page.