Forum Discussion
Solved
How to add another criteria to FILTER function
Hi all, I am using the FILTER formula in my spreadsheet and i need to have two criteria "J" and "jj". How do I modify this ? !B3:B241="J"
Tinny426 Put each criterion between brackets and join them together with + for an OR, or * for an AND.
If you want to check if B3:B241 contains either "j" or "jj" it could look like this:
=FILTER( .........., (B3:B241="j")+(B3:B241="jj") )
Hi, thanks for your suggestion, but it didn't seem to work.
Here is the full formula, which may help.
=SORT(FILTER('******************* SEP 11-27'!A3:C239,'****************** SEP 11-27'!B3:B239="j"),3,-1)
I need the results to include rows with both J and JJ in column B3:B239
Thanks Rintinman.
