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:
so in real life it could look like d2:
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.
Bookmarks