Hello and Welcome to Excel Forum TallTex
If I understand you want all of the conditions to be true, so it is not STE and not PO Box and not APT and TX and Y
That being the case they all need to be on the same line (they all carry the same weight) so the criteria range will be A1:K2 (as seen in the attached file).
Let us know if you have any questions.
Bookmarks