Hello,
I apologize if this has already been answered, I could not find the answer anywhere.
I have a large database (almost 400,000 records) each with a customer's name, address etc, year & month, and sales. I have found many records with the same zip code but somehow have a different city/town name. Is there any way to isolate these so I can correct each?
Example:
County Zip Code City State
YORK 03902 CAPE NEDDICK ME
YORK 03902 YORK ME
YORK 03903 ELIOT ME
YORK 03903 ELLIOT ME
YORK 03903 KITTERY ME
YORK 04002 ALFRED ME
YORK 04002 LYMAN ME
YORK 04005 BIDDEFORD ME
YORK 04005 BIDDEFORD, ME
CUMBERLAND 04011 BIRCH ISLAND ME
CUMBERLAND 04011 BRUNSWICK ME
Thanks in advance for any help.
I apologize if this has already been answered, I could not find the answer anywhere.
I have a large database (almost 400,000 records) each with a customer's name, address etc, year & month, and sales. I have found many records with the same zip code but somehow have a different city/town name. Is there any way to isolate these so I can correct each?
Example:
County Zip Code City State
YORK 03902 CAPE NEDDICK ME
YORK 03902 YORK ME
YORK 03903 ELIOT ME
YORK 03903 ELLIOT ME
YORK 03903 KITTERY ME
YORK 04002 ALFRED ME
YORK 04002 LYMAN ME
YORK 04005 BIDDEFORD ME
YORK 04005 BIDDEFORD, ME
CUMBERLAND 04011 BIRCH ISLAND ME
CUMBERLAND 04011 BRUNSWICK ME
Thanks in advance for any help.