Zip code filtering

  • Thread starter Thread starter Zack
  • Start date Start date
Z

Zack

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?
 
you'd want to have a column with =left(value,5) formula to look at only the
first 5 characters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup function Question 5
How to merge Excel address columns when some zips begin with zeros 4
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
Excel 2007 is stupid dealing with zipcodes 2
mixing zip with zip+4 and then sorting 2
look up zip code 4
Changing ZIP code formats in Excel 2003 6
Sort by how many addresses per zip code 4

Back
Top