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 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