SORTBY(array, by_array1 [,sort_order1] [,by_array2] [,sort_order2]) |
Returns the array of data in a range that has been sorted and satisfies multiple conditions. |
| array | The array or range to sort. |
| by_array1 | The array or range to sort on. |
| sort_order1 | (Optional) The order to use for sorting 1 for ascending, -1 for descending. |
| by_array2 | (Optional) The array or range to sort on. |
| sort_order2 | (Optional) The order to use for sorting 1 for ascending, -1 for descending. |
Remarks |
| * This function is only available in Office 365 to Office Insiders at the moment. * For the Microsoft documentation refer to support.office.com |
|
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top