Forum Discussion
How to add another criteria to FILTER function
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") )
Similar to what I suggested earlier, that would then be:
=SORT(FILTER('******************* SEP 11-27'!A3:C239,('****************** SEP 11-27'!B3:B239="j")+('****************** SEP 11-27'!B3:B239="jj")),3,-1)
Obviously, when there are no rows that match these criteria (either j or jj), then SORT will error out, and you need to wrap the formula in IFERROR. Something like this:
=IFERROR(SORT(FILTER('******************* SEP 11-27'!A3:C239,('****************** SEP 11-27'!B3:B239="j")+('****************** SEP 11-27'!B3:B239="jj")),3,-1), "No match")
Thanks for your help Riny, all working now.
Richard.
