Excel: 2021, 365, for Mac and web
Excel appeared in 1987, and only after 34 years create the formula SORT ????? Impossible!
Example of use
The SORT function sorts the contents of a range or array in ascending or descending order. Values can be sorted by one or more columns. SORT returns a dynamic sequence of results.
It is extremely easy to use.
Syntax
=SORT (array, [sort_index], [sort_order], [by_col])
- array – Range or array to sort.
- sort_index – [optional] Column index to use for sorting. Default is 1.
- sort_order – [optional] 1 = Ascending, -1 = Descending. Default is ascending order.
- by_col – [optional] TRUE = sort by column. FALSE = sort by row. Default is FALSE.