Sorts the rows of a given array or range by the values in one or more columns.
Sample Usage
SORT(A2:B26, 1, TRUE)
SORT({1, 2; 3, 4; 5, 6}, 2, FALSE)
SORT(A2:B26, C2:C26, TRUE)
Syntax
SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...])
-
range
- The data to be sorted. -
sort_column
- The index of the column inrange
or a range outside ofrange
containing the values by which to sort.- A range specified as a
sort_column
must be a single column with the same number of rows asrange
.
- A range specified as a
-
is_ascending
-TRUE
orFALSE
indicating whether to sortsort_column
in ascending order.FALSE
sorts in descending order. -
sort_column2, is_ascending2 ...
- [ OPTIONAL ] - Additional columns and sort order flags beyond the first, in order of precedence.
Notes
range
is sorted only by the specified columns, other columns are returned in the order they originally appear.
See Also
FILTER
: Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions.
Examples
Sorts the rows in the specified data range according to the given key columns followed by the sorting order.