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