Excel Function: RANK

The Excel function RANK determines the rank of a value based on a set of values (for ranking values, for example).


=RANK(value, array, order)

Example of use

The objective here is to assign a ranking to the participants based on their number of points:

excel function rank

Select the RANK function and enter:


rank function png

Click OK.

excel function ranking participants rank

Before copying, add $ to the cell range to prevent it from being shifted, then drag the formula down:

The participants "Participant 2" and "Participant 8" would normally occupy places 4 and 5 but since they scored the same number of points, they both occupy the fourth place (and rank 5 has therefore not been attributed).
If needed, you can download the Excel file used here: rank.xlsx