10.2 Sorting of row-based data

 

Here below is a data table:

imagepng

Sort in ascending order by TotalScore:

=spl("=E(?).sort(TotalScore)",A1:C12)

imagepng

Sort in descending order by TotalScore:

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

imagepng