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