Returns an array of sorted rows or columns from the specified range.
Syntax
 Copy Code
|
|---|
SORT( ReferenceOrArray range, Integer sortIndex, Integer sortOrder, [Logical byCol = FALSE] ) → Array |
Parameters
- range
- Required. The range or array to sort.
- sortIndex
- Optional. The index of row or column in the range by whose values to sort. Default is 1.
- sortOrder
- Optional. 1 (default) for ascending order, or -1 for descending order.
- byCol
- Optional. FALSE (default) to sort by rows, or TRUE to sort by columns.
Remarks
Results spill into cells adjacent to the one that calls SORT. If they are occupied, the formula returns #SPILL error.
See Also
Function Reference
FILTER Function
UNIQUE Function