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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656205933630
https://c.scudata.com/article/1656298161727