10.11 Ranking of row-based data - by combination of multiple columns

 

Here below is a data table:

imagepng

To rank (in descending order) by the order combination of three columns Maths, English, and PE, enter in cell F2:

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

imagepng

Drag F2 down to every relevant row:

imagepng