Formula to calculate distance between zip codes

Register To Reply. Re: How do calculate distance between 2 zip codes. Always put your code between code tags. Re: How do calculate distance between 2 zip codes I just picked a web site at random and then used Excel's Import Data tool to import the results of a zipdistance search on that site. Then looped that macro to compare every column A value to F1 and put the results in column B.

Last edited by JBeaucaire; at PM. For instance, if you're searching for restaurants, a Web site will often allow you to enter a ZIP code and display all restaurants within x miles of that ZIP code. For instance, if you're searching for restaurants, a Web site will often allow you to enter a ZIP code and display all of the restaurants within X miles of that ZIP code.

Here is one way application developers to implement a ZIP code distance calculator using the. NET Framework and C. You will need to take this data and either import it into a database or transform it into an XML document. The ZIPCode class contains the following:. Once we've done this, we do the same thing for the other ZIP code.

It uses Yahoo geocoding and requires a Yahoo account, it works great for the US but not very good for the UK, so I abandoned it but it may be useful to you. I think the returned value is a fastest road directions, not as the crow flies. I compared between directions on the webpage and the macro, and that was the same distance, Which between my TN to WA locations there is no straight road path You must log in or register to reply here.

Similar threads Z. Replies 1 Views Dec 17, Fluff. Bullflip Jun 15, Excel Questions. Replies 8 Views 2K. Jan 5, Ion. Replies 5 Views 1K. Jun 1, ardykav. Replies 4 Views Nov 19, angie Question Postcode finder in Excel and caculate the distance between two postcodes.

Just curious I'd figure this myself, but when there are math wizards out there Hey - good question. I'm going to take a guess. Then I'll definitely have to think about it some more Arnold Fribble Yak-finder General Posts. X Not Just a Number Posts. I always thought it was the Great Circle Formula End Function Brett Does anyone have any idea how we could do a similar thing for UK post codes. The cause of - and solution to - all of life's problems. Kristen Test Posts.

We use an XML feed to www. Thanks Kristen I'll take a look at that steve To alcohol!