In my list I am trying to filter out Shippers (to my company) that are
charging
us for shipments to other companies. I have a list of our locations and
want to use either the city or zipcode to filter out the shipments that are
not to our company

I have not had alot of luck using formulas with the Advance Filter Critera

The below formula gives me when they are shipping to my company by city

=ISNA(MATCH('Wrong Vendor'!$H$2,FedEx!$I$1:$I$312,0))

I need the reverse of this. So I get a list of shipments that are NOT to my
company.

Thanks, Krystal Peters