So i have a table like the one below (but much larger, showing multiple states):
<tbody>
</tbody>
Is there a formula or macro I can use that will give me the shortest distance to the nearest Company ID by Latitude and Longitude in an adjacent column?
Company ID | State | Zip Code | Latitude | Longitude | Closest Company ID Distance (miles) | ||
37 | AK | 99503 | 61.1988159 | -149.9060107 | |||
80 | AK | 99518 | 61.17353626 | -149.883512 | |||
230 | AK | 99654 | 61.56331423 | -149.2925177 | |||
353 | AK | 99654 | 61.57614692 | -149.4098359 | |||
270 | AK |
<colgroup><col></colgroup><tbody> </tbody> | 60.50016076 |
<colgroup><col></colgroup><tbody> </tbody> | |||
272 | AK |
<tbody> </tbody> | 60.52622641 |
<tbody> </tbody> | |||
81 | AK | 99701 | 64.836296 | -147.715406 |
<tbody>
</tbody>
Is there a formula or macro I can use that will give me the shortest distance to the nearest Company ID by Latitude and Longitude in an adjacent column?