Excel Rank function

To RANK exam results from highest to lowest using the Excel RANK function as per below: –

Excel rank function

Make up of the RANK() function

=RANK(cell value, cell range,ascending/descending)

The above example

=RANK(C5,$C$3:$C$17,0)

Ranks the values in column C against the other values between C3 and C17 and rank in ascending order.