Postcode calculations

[ukman2012]

'm seeking help, assistance and advice. I've got an area postcode and when every segment of that area postcode is broken down, its 28503 segment. Im trying to work out this distance between each postcode, for example, NG1 1AA - NG1 1AA = 0 miles, and so on..

[FDibbins]

please provide a bit more of an explanation. if it would help to explain, please upload a sample workbook, showing your data, what your expected outcome is, and how you arrived at that

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Kevin UK]

I seen something similar here, might be worth reading!!

http://www.excelforum.com/tips-and-t...rivetimes.html

[ukman2012]

I've attached a workbook of what i am trying to create. I want to be able to calculate the distance between each post code sectors, I've got a workbook which also has the longitude and latitude of every postcode sector. Appreciate any advice or help.