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
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 for John Winter or Bill Gates would displayed as 1.5 counting the two duplicate values.