SORT

Returns an array of sorted rows or columns from the specified range.

Syntax

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