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) The number indicating the row or column to sort by.|
|sort_order||(Optional) The 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 Microsoft 365 and was released in July 2020.|
* This function can return a Dynamic Array Formula.
* You can use the FILTER function to filter and sort your data.
* You can use the SORTBY function to return an array of data that has been sorted.
* For the Microsoft documentation refer to support.office.com
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top