Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standardizing Street Addresses in a Large Address Database
I have been trying to come up with a way to have the computer help me
with a database of homes listed by address. My problem is probably not uncommon in that the addresses for a property can be entered differently by different people who enter them into the database. For example, St. vs. Street, suffixes such as NW, or SE, 1st Street vs. First St., etc. The permutations are enormous. I have tried sorting by address to group them as best I can, but then I am having to just look at them to try to decide which ones are actually the same physical property address. I could do that for a small database, but this one can have more than 100,000 property records in it. There is no other common field in the database other than the street address, so it looks like I'm stuck with trying to group them, somehow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO ALPHBETIZE STREET ADDRESSES | Excel Discussion (Misc queries) | |||
Sorting street addresses | Excel Discussion (Misc queries) | |||
Help! How to sort addresses by street then by #...... | New Users to Excel | |||
Working with street addresses? | Excel Discussion (Misc queries) | |||
Why is there a box symbol at the end of my street addresses in on. | Excel Discussion (Misc queries) |