10.3 Sorting of row-based data - by combination of multiple columns

 

Here below is a data table:

imagepng

Sort in reverse order by the order combination of three columns (Maths, English, PE):

=spl("=E(?).sort(Maths:-1,English:-1,PE:-1)",A1:E12)

imagepng