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


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