Forum Discussion
Solved
Need help with SORTBY function.
Hi all, In reference to this formula, SORT(FILTER('Big 4 NOV 21-23'!A3:D221,'Big 4 NOV 21-23'!B3:B221="M"),3,-1) I can only sort using one column (3). I need to sort the rows by column 3 then colum...
You do not need SORTBY() in this case. You can specify multi column for sorting and individual sort order for each column.
=SORT(FILTER('Big 4 NOV 21-23'!A3:E221,'Big 4 NOV 21-23'!B3:B221="M"),{3,4,5},{-1,-1,-1})
You do not need SORTBY() in this case. You can specify multi column for sorting and individual sort order for each column.
=SORT(FILTER('Big 4 NOV 21-23'!A3:E221,'Big 4 NOV 21-23'!B3:B221="M"),{3,4,5},{-1,-1,-1})
