I first put the attached file together some years ago, and I've mentioned it on one post here soon after I joined and have had a few PMs asking for a copy, so I thought I might as well submit it here.
The file works out the distance in miles between 2 UK postcodes. On the Single sheet you can enter the two postcodes in B3 and B4 (just up to the first space), and on the Multiple sheet you can enter several postcodes on different rows in columns A and B, where, for example, you might have one central location and need to know the distances to travel from other locations.
The file uses a lookup table containing lattitudes and longitudes, and calculates the straight-line distance between the "nominal" centre of each postcode.
Hope this is of use to some of you.
Pete
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Hi, I am looking for a way to calculate distance (ideally in KM) between two UK post codes (one static location to multiple others), using Excel.
Can you help please? Thanks.
Bump