ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Distances between Postal Codes (https://www.excelbanter.com/excel-discussion-misc-queries/91524-distances-between-postal-codes.html)

Irfan

Distances between Postal Codes
 
Hello There,

I am working with two lists. One is a list of Service Locations and the
other is a list of retail stores. I am trying to find out how far the retail
locations are from the Service Locations using their Postal Codes.

Is there a way to find the distance between two postal codes? I am really
stuck and am hoping that this does not have to be done manually.

Thank you in advance,
Irfan

Paul Lautman

Distances between Postal Codes
 
Irfan wrote:
Hello There,

I am working with two lists. One is a list of Service Locations and
the other is a list of retail stores. I am trying to find out how
far the retail locations are from the Service Locations using their
Postal Codes.

Is there a way to find the distance between two postal codes? I am
really stuck and am hoping that this does not have to be done
manually.

Thank you in advance,
Irfan


You can call the Google Maps directions API. That'll give a distance by road
as opposed to as the crow files.




All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com