Hi Excel Geniuses
I've got a doozy of a question. I'm trying to take a center point (lat/long) and then use that value to reference a table to find the three closest matches by lat/long proximity.
Here is a simplified example:
The first spreadsheet has the centering location value and we want to populate the three closest cities from referencing the second table
<tbody>
</tbody>
The second table is thousands of rows long and has one lat/long per row
<tbody>
</tbody>
Any idea how to use either a formula or VBA to make these proximity matches??
Thanks!!!
I've got a doozy of a question. I'm trying to take a center point (lat/long) and then use that value to reference a table to find the three closest matches by lat/long proximity.
Here is a simplified example:
The first spreadsheet has the centering location value and we want to populate the three closest cities from referencing the second table
Location | Latitude | Longitude | Closest City 1 | Closest City 2 | Closest City 3 | ||
San Fran |
<tbody> </tbody> | -122.460533 | |||||
<tbody>
</tbody>
The second table is thousands of rows long and has one lat/long per row
Location | Latitude | Longitude | ||
Denver |
<tbody> </tbody> | -104.756684 | ||
Chicago |
<tbody> </tbody> | -87.7467 | ||
Cleveland |
<tbody> </tbody> | -81.787063 | ||
Asheville |
<tbody> </tbody> | -82.60152 | ||
Houston |
<tbody> </tbody> | -95.538717 | ||
<tbody>
</tbody>
Any idea how to use either a formula or VBA to make these proximity matches??
Thanks!!!
Last edited: