Distance between two different Zip Codes

[gymwrecker]

I'm working on a project with over 1800 records. I have been given Zip Codes from Point A to Point B. The question is, in Excel (2007), is there a way to determine distance from Zip Code A to Zip Code B?

 

[ZAX]

Try This "=CELL("Row",Zip Code A Address)-CELL("Row",Zip Code B Address)"

ZAX

 

[shg]

You need the lat/lon of the zip codes, which you can find online. Then you could calculate distances as in the post at [SOLVED] Getting the Minimum Distance (Formula Given)