SORT(array [,sort_index] [,sort_order] [,by_col])
Returns the array of data in a range that has been sorted.
|array||The 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 support.office.com
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top