Filter contact list by zip codes from a list

[rafayhaq]

I have a huge contact list with headers- Name, Address, Zipcodes.

But we only serve around 2000 zipcodes, I want to filter my contact list on the basis on those 2000 zipcodes. So that I can find those contacts that pertain to my serviable zip codes and eliminate the rest.

Doing this manually by using the simple excel filter is very tedious, can anyone help me out with this?

[Kaper]

Hi,
Does it really fit into: https://www.excelforum.com/access-tables-and-databases/ ?
You mentioned "using the simple excel filter"

If it's excel, Id recommend:
1) write whole list of zipcodes you serve in one column somewhere in your spreadsheet (you probably have it already)
2) next to your main contactlist write a formula:

=countif(range_with_served_zipcodes,your_zipcode)

so in real life it could look like d2:

=countif(H$2:H$2001,C2)

this assumes Name, Address, Zipcodes are in columns A:C, list of served zipcodes in column H, row 1 - headers

copy down

and now you can filter out zeros (you shall have only 0 and 1 results of this formula. if you got bigger number it means there are duplicates in served zipcodes list.