-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Distance Calculator for excel between two citys with kilometer result
DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,659
- Office Version
- 365
- Platform
- Windows
Perhaps this will help. Follow all these links and something in one of those threads will be what you need.
Just create a grid and use the fancy trigonometry formula to calculate the distances between each location. Create Data Validation boxes for your two lat/long locations and have a lookup formula search the grid.
https://www.mrexcel.com/forum/excel-questions/966498-create-territories.html#post4639594
this too:
https://www.mrexcel.com/forum/excel-...t=great+circleJust create a grid and use the fancy trigonometry formula to calculate the distances between each location. Create Data Validation boxes for your two lat/long locations and have a lookup formula search the grid.
https://www.mrexcel.com/forum/excel-questions/966498-create-territories.html#post4639594
this too:
Last edited:
Upvote
0
