Excel Rank function
To RANK exam results from highest to lowest using the Excel RANK function as per below: –
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.