Hi All
Long time reader, first time poster!
I really need some help with a spreadsheet I'm creating... I have a list of building locations which all have latitude/longitude coordinates. At the top I then have a drop box for the home location.
What I want the sheet to do is, when a home location is chosen in the top section, the distances to all of the other locations calculate in the bottom section.
Capture.JPG
I know I can do distance calculations on a 1>1 basis, but not sure how to do it on a 1>Many basis.
I have attached an example file.
Thanks in advance for any help...
Bookmarks