Here below is a data table:

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)

Drag F2 down to every relevant row:

esProc Desktop and Excel Processing
10.10 Ranking of row-based data
10.12 Ranking of row-based data - by expression