SORT(array [,sort_index] [,sort_order] [,by_col])

Returns the array of data in a range that has been sorted.

arrayThe range, or array to sort.
sort_index(Optional) A number indicating the row or column to sort by.
sort_order(Optional) A number indicating the desired sort order:
1 = for ascending order (default)
-1 = for descending order
by_col(Optional) A logical value indicating the desired sort direction:
FALSE = to sort by row (default)
TRUE = to sort by column


* This function is only available in Office 365 to Office Insiders at the moment.
* You can use the FILTER function to filter and sort your data.
* For the Microsoft documentation refer to


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top