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
Ranks the values in column C against the other values between C3 and C17 and rank in ascending order.