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") )
Another method, especially if you have more than two criteria to meet:
=SORT(FILTER('******************* SEP 11-27'!A3:C239, ISNUMBER(MATCH('******************* SEP 11-27'!B3:B239, {"j";"jj"}, 0)), "NA"),3,-1)you can set up the matrix {"j";"jj"} with all strings you need.