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.

arrayThe array or range to sort.
by_array1The 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

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top