» UK Postcode Distance Calculator
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
Book Store:
Recommended Books:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Marketing Planning for Services
- PowerPoint® 2002 For Dummies®
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
