Using AutoFilter Criteria1 for list of NOT included

**fpperryaz** · 01-29-2016, 06:45 PM

I have a list of addresses from which I need to exclude those from about 20 ZIP Codes. Is it posible to use the AutoFilter Criteria1 for that purpose. Perhaps an Array of NOT included ZIPcodes?
If not, are there any other suggestions?
Thanks,
Frank

**walruseggman** · 01-29-2016, 06:51 PM

No, you can only filter 2 not equal criteria using AutoFilter.

The alternative is to use VBA to simulate autofilter to hide rows; using this method, you can have unlimited not equal criteria.

**Pete_UK** · 01-29-2016, 06:57 PM

Use a blank column next to your data and put a formula in there which looks to see if the zip code on a particular row is one of your group to be ignored, e.g. with a formula like this in row 2:

=IF(ISNUMBER(MATCH(D2,$X$1:$X$20,0)),"ignore","okay")

where column D contains the zip codes for your addresses and X1:X20 contains the zip codes to be excluded. Copy this down, then filter on this column and select "okay".

Hope this helps.

Pete