Forum Discussion
Advanced Filters, is it possible colA=("a" OR "b" OR "c") AND colB=("1" OR "2" OR "3") on one row?
Doing some diagnostics of mail delivery failures of messages within several domains all under the same Office 365 tenant. So, looking for messages with domains a.com, b.com, and c.com as part of ...
Let the data be in A:B with headers in A1:B1 and the criteria range I1:I2 with header left blank and this formula in I2:
=SUMPRODUCT(COUNTIFS(A2,{"*@a.com","*@b.com","*@c.com"}))+SUMPRODUCT(COUNTIFS(B2,{"*@a.com","*@b.com","*@c.com"}))=2
Sorry never got back. I was new here and lost the link.
Your solution looks like an array(?) formula since it has the curly braces {}. I've always struggled to understand them but will definitely give it a try.
Thank you.