We help IT Professionals succeed at work.

Distance between two zip codes using Excel

BBlu
BBlu asked
on
Does anyone know how, via VBA or an advanced formula/function in Excel, to calculate the distance between two zip codes, if given the latitude and longitude coordinates like those on the attached?
ZIP-CODES.xlsx
Comment
Watch Question

Commented:
In miles:

=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) * 3958.756


Source: http://bluemm.blogspot.com/2007/01/excel-formula-to-calculate-distance.html
Commented:
In this Linkedin discussion there were some other solutions about calculation distance between zip codes:
http://www.linkedin.com/groups/Distance-between-Zip-Codes-3843467.S.97120237?trk=group_search_item_list-0-b-ttl&goback=.gna_3843467

Author

Commented:
Thank you both very much. Awesome solutions!