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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656138724409
https://c.scudata.com/article/1656205933630