This article describes the syntax and example of the RANK function in Microsoft Excel. The Excel RANK function returns the rank of a number in a list of numbers.
Syntax = RANK (number, ref, [order])
Number = value whose rank is to be calculated.
Ref = the values against which the rank is calculated.
For Example
Find the students RANK.
Note
When we drag this formula down, the absolute reference ($B$5:$B$12) stays the same, while the relative reference (B5) changes to B6, B7, B8, etc.
RANK.AVG Function
Use RANK.AVG to return the average rank if more than one number has the same rank.
For Example
Find the rank when you have same percentage.
Return the average rank.