Calculate distance between 2 addresses without having latitude?

[zinah]

Hi,

I have 2 columns that have address and I need to know if there's a way to calculate the distance in miles or KM. The challenges is there's no latitude and only full address (which includes the zip code). Any formula to accommodate this?


Thank you!

EDIT: Sorry I meant Latitude and longitude, and I have different countries including USA.

 

[GlennUK]

Well, other countries won't have a ZIP code anyway, as that is the USA postal area identifying system. Are you saying that whatever method you require needs to convert not only ZIP code to latitude and longitude, but also that every other country's postal id system should be converted in the same way?

 

[zinah]

Well, other countries won't have a ZIP code anyway, as that is the USA postal area identifying system. Are you saying that whatever method you require needs to convert not only ZIP code to latitude and longitude, but also that every other country's postal id system should be converted in the same way?

Correct @GlennUK , what I need is to get the distance between any two locations (zip/postal code) without having the latitude and longitude.

Thank you,
Zina

 

[GlennUK]

This is not an Excel problem. If you can find a method that anyone, anywhere uses for this, then post that back in your reply, and I'm sure someone will convert that to an Excel method for you .... but you need to say how that method is supposed to work.

 

[zinah]

This is not an Excel problem. If you can find a method that anyone, anywhere uses for this, then post that back in your reply, and I'm sure someone will convert that to an Excel method for you .... but you need to say how that method is supposed to work.

So there’s no way to calculate the distance between 2 zip codes?

 

[GlennUK]

So there’s no way to calculate the distance between 2 zip codes?

That is a tiny subset of what you requested ... and people have asked that before: Calculate Distance between Zip Codes

 

[BSALV]

one by one with Google Maps (API needed ?)