Search
Clear search
Close search
Google apps
Main menu

During routine maintenance, a number of users were signed-out from their Google accounts. If you were affected, please sign back in using your usual username and password at https://accounts.google.com. If you can’t remember your password or can’t sign in for another reason, recover your account password here.

SORT

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 in range or a range outside of range 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 as range.
  • is_ascending - TRUE or FALSE indicating whether to sort sort_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:

Examples

Sorts the rows in the specified data range according to the given key columns followed by the sorting order.

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?