Excel function RANK

The RANK function makes it possible to sort values in increasing or decreasing order.

An example:

What we are trying to do is to assign a rank to each of these 12 people based on their scores.

Select the RANK function.

Click OK.

rank function

After AutoFill, all the ranks will be displayed.

Alexander and Aurelia have the same score. They are both given rank 6. Rank 7 has not been assigned at all.