10.10 Ranking of row-based data

 

Here below is a data table:

imagepng

To calculate the ranking of students by TotalScore (in descending order), and fill in the results in corresponding cell of column D, enter in cell D2:

=spl("=?1.conj().rank@z(?2)",C$2:C$12,C2)

imagepng

Drag D2 down to every relevant row:

imagepng