RANK.EQ and RANK.AVG functions in Excel

Excel 2016, 2013 & 2010 has RANK function that helps users to find the rank value from a set of values. Let us see the usage of RANK function with an example.

RANK.EQ function displays the rank of a value from a list of values in the specified sort order.

Now if you want to find out the rank of David Blanc in the above data set then type

=RANK.EQ(I6,I5:I9,0)

Where I6 refers to the Marks obtained by David Blanc, I5:I9 refers to the list of values that needs to be used for finding out the rank and 0 refers to the sort order.

Similarly RANK.AVG function displays the rank of a value from a list of values in the specified sort order but it also counts the duplicate entries in the dataset and displays the average of all duplicate values.

=RANK.AVG(I6,I5:I9,0)


RANK.AVG for John Winter or Bill Gates would displayed as 1.5 counting the two duplicate values.

In Category: Blogging

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.