Forum Discussion

Tinny426's avatar
Tinny426
Copper Contributor
Nov 23, 2025
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...
  • Harun24HR's avatar
    Nov 24, 2025

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

     

Resources