Forum Discussion

Tinny426's avatar
Tinny426
Copper Contributor
Sep 20, 2022
Solved

Want to add another condition to an array.

Hello all, I have a formula that moves info from one spreadsheet to another. its working great, but.......... I want to add another condition. This is the formula i am using. =SORT('Mix...
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Sep 20, 2022

    Tinny426 From your current formula it seems you are just sorting data. Do not apply any condition. If you want to apply condition to keep only "S" then use FILTER() function and then apply SORT() function.

    =SORT(FILTER('Mixed species SEP 9-11'!A5:D100,'Mixed species SEP 9-11'!C5:C100="S"),3,-1)
Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 20, 2022

Tinny426 From your current formula it seems you are just sorting data. Do not apply any condition. If you want to apply condition to keep only "S" then use FILTER() function and then apply SORT() function.

=SORT(FILTER('Mixed species SEP 9-11'!A5:D100,'Mixed species SEP 9-11'!C5:C100="S"),3,-1)

Resources