Chihiro
Excel Ninja
Recently had question asked about Havarsine UDF I posted while back.
http://chandoo.org/forum/threads/power-map.31577/#post-187726
Here's tool demonstrating how it can be utilized.
This calculates distance from selected zip's lat/long and grabs all zip that's within specified distance of it and compiles info in new sheet.
Zip/Geo code info taken from link below:
https://www.gaslampmedia.com/download-zip-code-latitude-longitude-city-state-county-csv/
http://chandoo.org/forum/threads/power-map.31577/#post-187726
Here's tool demonstrating how it can be utilized.
This calculates distance from selected zip's lat/long and grabs all zip that's within specified distance of it and compiles info in new sheet.
Zip/Geo code info taken from link below:
https://www.gaslampmedia.com/download-zip-code-latitude-longitude-city-state-county-csv/