Hi guys,
Long time reader, first time poster, but I'm having a problem which i can't find a solution to on the forum.
I have a list of 700 locations (names - Column A) and their latititude (Column B) and longitude (Column C), and I'm looking to return the nearest three locations to the right, along with their distance (i.e. Nearest (Column D), Distance to nearest (Column E), second nearest (Column F), etc.
I found something similar for weather stations but I couldn't adapt as the excel spreadsheet seemed to corrupt when I was using it, and just repeatedly crashed.
If anyone could help using formulas or VBA that would be great! The distances can be as the crow flies and it doesn't matter hugely which distance model is used, whichever is easiest really.
Any help would be much appreciated. I can provide sample data if necessary, but it's a pretty straight forward 3 column spreadsheet at the moment
Thanks,
Bookmarks