Good morning Excel community,
I was hoping you guys could help me out with something.
So I have a list with locations and their coordinates:
Column A: Location ID
Column B: Coordinate X
Column C: Coordinate Y
Example:
PG423 648322 246675
PL423 648321 246674
PF423 653510 246900
PT435 653505 246900
So, what am I actually looking for?
I want to know the distance between the locations and see what locations are closest to the one I analyse.
In a perfect world I would have for each location a list showing what other locations are closest (the best would be a list sorted by distance).
I already found out how to compare two locations and show the distance in meter, however I feel like I am still far away from an actual sorted list. I am not even sure if it’s possible without using VBA.
It would be nice if I put a Location ID in some cell and then it shows me the list with all other locations, sorted by distance and showing the meters.
I hope I managed to explain myself, if not please let me know.
I really really appreciate your help.
Thank you so much in advance!
Best,
AFGP
Bookmarks