Want to add another condition to an array.

[Tinny426]

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('Mixed species SEP 9-11'!A5:D100,3,-1)
In the array A5:D100, column C has the letters "S and "J" in random order down the column.
I want to catch only the rows with "S" in column C, whilst keeping the other conditions is use.
Can this be done? i think i have given enough information above, but i can add screenshots if required.
Cheers Richard.

[#2 · Accepted solution]

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