SORT( this-list[, from-high-to-low?] )


SORT() returns the items of this-list (a list of any type) sorted in either ascending/first-to-last/low-to-high or descending/last-to-first/high-to-low order according to from-high-to-low? (a Yes/No value).

Return Value

A new list containing the items of this-list in sorted order. If from-high-to-low? is TRUE, the result will be sorted in descending order; if FALSE or omitted, the result will be in ascending order.

See Also

List Expressions, List Functions, ANY(), INDEX(), LIST(), MAX(), MIN(), ORDERBY(), TOP(), UNIQUE()

Did this answer your question?