SORT
Returns a table sorted by a column (1 for smallest first, -1 for largest first). The result fills the empty cells below and beside the formula.
Group: Dynamic arrays
Syntax
SORT(range, [sort_column], [order])Example
Exampleexcel
WeCodeAcademyWeCodeAcademyReturns a table sorted by a column (1 for smallest first, -1 for largest first). The result fills the empty cells below and beside the formula.
Group: Dynamic arrays
SORT(range, [sort_column], [order])