I finally got a list of all zip codes with the Latitude and Longitude of each.

I am looking for an Excel formula I can use to determine mileage between 2
zip codes based on their Latitude and Longitude. I have found several but
have been unable to get them to work in Excel. The following is an example
of what I have to work with.

Zip Latitude Longitude
23219 37.541696 -77.439204 Richmond VA

20315 38.928861 -77.017948 WASHINGTON DC

Any and all help/assistance will be greatly appreciated.

Thanks

You may check the Chip Pearson page on Latitute and Longitude:
http://www.cpearson.com/excel/latlong.htm
There are some formulas there that can be what you need.

Hope this helps,
Miguel.

"Adams135" wrote:

I finally got a list of all zip codes with the Latitude and Longitude of each.

I am looking for an Excel formula I can use to determine mileage between 2
zip codes based on their Latitude and Longitude. I have found several but
have been unable to get them to work in Excel. The following is an example
of what I have to work with.

Zip Latitude Longitude
23219 37.541696 -77.439204 Richmond VA

20315 38.928861 -77.017948 WASHINGTON DC

Any and all help/assistance will be greatly appreciated.

Thanks

Thanks ... that did the trick.

I appreciate your help.

"Miguel Zapico" wrote:

You may check the Chip Pearson page on Latitute and Longitude:
http://www.cpearson.com/excel/latlong.htm
There are some formulas there that can be what you need.

Hope this helps,
Miguel.

"Adams135" wrote:

I finally got a list of all zip codes with the Latitude and Longitude of each.

I am looking for an Excel formula I can use to determine mileage between 2
zip codes based on their Latitude and Longitude. I have found several but
have been unable to get them to work in Excel. The following is an example
of what I have to work with.

Zip Latitude Longitude
23219 37.541696 -77.439204 Richmond VA

20315 38.928861 -77.017948 WASHINGTON DC

Any and all help/assistance will be greatly appreciated.

Thanks

Hi Adams135,

I'm looking for a list of zip code lat & long. Where did you get yours?

Thx
tuffgil

"Adams135" wrote:

Thanks ... that did the trick.

I appreciate your help.

"Miguel Zapico" wrote:

You may check the Chip Pearson page on Latitute and Longitude:
http://www.cpearson.com/excel/latlong.htm
There are some formulas there that can be what you need.

Hope this helps,
Miguel.

"Adams135" wrote:

I finally got a list of all zip codes with the Latitude and Longitude of each.

I am looking for an Excel formula I can use to determine mileage between 2
zip codes based on their Latitude and Longitude. I have found several but
have been unable to get them to work in Excel. The following is an example
of what I have to work with.

Zip Latitude Longitude
23219 37.541696 -77.439204 Richmond VA

20315 38.928861 -77.017948 WASHINGTON DC

Any and all help/assistance will be greatly appreciated.

Thanks