10.5 Sort in group

 

Here below is a data table:

imagepng

Sort the data (in ascending order) by Class, (in descending order) by Score:

=spl("=E(?1).sort(Class,Maths:-1)",A1:C12)

imagepng

esProc Desktop and Excel Processing
10.4 Sorting of row-based data - by expression
10.6 Sort by specified order