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 |
Remarks |
| * This function is only available in Microsoft 365. * 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 |
|
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top