ExcelBanter - Zip code filtering

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Zip code filtering (https://www.excelbanter.com/excel-discussion-misc-queries/203956-zip-code-filtering.html)

Zack

Zip code filtering

How can I filter a database so that in the zip code field, a 5 digit zip code
is not unique from a duplicate record where the same record is listed but
with 9 digits?

Sean Timmons

Zip code filtering

you'd want to have a column with =left(value,5) formula to look at only the
first 5 characters.

"Zack" wrote:

How can I filter a database so that in the zip code field, a 5 digit zip code
is not unique from a duplicate record where the same record is listed but
with 9 digits?

All times are GMT +1. The time now is 10:44 PM.