I have a large number of address pairs in an excel file and I am trying to find a cheap (or free) solution to easily calculate the distance between the PRIMARY ADDRESS AND EACH ADDRESS IN THE FILE. I have found a couple of solutions that do this for zip codes, but not for a physical address. As always, and all suggestions are Appreciated. I am using Windows 10 and Excel 2016. See attached file
Without coordinates or a post code (zip code), I cannot see any way of doing this. I am sure there are multiple Cleveland Avenues in the USA. Even using the data you have (address, city and state), you'd still need to link that data to a recognised location 'pin' such as post code or coordinates, the latter being preferred as a post code is never exact, and can cover quite a large area.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I think I can geo code them. If so, is there a way then to find the distance between the Primary and the others from the Primary?
Well, yes, probably, but we'd need to know what we are dealing with. Can you provide a workbook with some sample geo codes?
Yes, See attached.
Have a look here: https://www.contextures.com/excellatitudelongitude.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks