Hi I have a very hard question but im sure someones probably already done this and may have some code or formulas.
I have a sheet in a workbook with 100 locations in it. The places are all matched with a post code. It is the beginning part of the post code only. In another sheet I have a giant lookup table full of postcodes along with their longitude and latitude. The download page was
http://www.freemaptools.com/download...de-lat-lng.htm
and it does have an sql file with it but I dont know if its compatible with excel.
What I would like to do is to be able to enter a post code into a new sheet and it calculate the distance from the post code to all the locations. Then i want it to output a list in ascending order by distance.
The website gives out references to some websites but the maths is too complex for me without explanation or example to work with.
This is one of the pages
http://en.wikipedia.org/wiki/Haversine_formula
Any help appreciated with this one guys would be good to get it working and useful for others aswell I think as an example spreadsheet sticky
Thanks for your help in advance
Bookmarks