10.1 Sorting of simple members

 

Here below is a data table:

imagepng

Sort in ascending order:

=spl("=?.sort()",A1:A10)

imagepng

Sort in descending order:

=spl("=?.sort(~:-1)",A1:A10)

imagepng


esProc Desktop and Excel Processing
9.14 Delete data that can be paired
10.2 Sorting of row-based data