Syntax :

==SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…) 

Parameters :

• The following parameter are :

array –

• The array or range that will be sorted.

by array1 –

• The array or range on which to sort.

[sort order1] –

• The sort order to employ. If you’re climbing, you get a 1 and if you’re falling, you get a -1. Default is on the rise.

[by array2] –

• The array or range on which to sort.

[sort order2] –

• The sorting order to employ. If you’re climbing, you get a 1 and if you’re falling, you get a -1. Default is on the rise.