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

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