-
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.
lon
-
P
Nearest Lon Lat to Waypoint Formula Issue
Have adapted an array formula from a previous thread - "Need to compare Latitude & Longitude coordinates to find closest office" The formula is in C2 and picks up Lon and Lat from A1 & A2 and locates nearest from H2:J7...- p500uk
- Thread
- distance lat lon nearest waypoint
- Replies: 0
- Forum: Excel Questions
-
6
distance between 2 coordinates
Consider this two point on the map: <tbody> latitude longitude 45.61782 9.41737 45.48568 9.20181 </tbody> The distance between each other is about 22km. What's the formula to calculate that? I tried different formulas found online but every one returned absurd values...- 6diegodiego9
- Thread
- 22km coordinates distance lat lon
- Replies: 11
- Forum: Excel Questions
-
R
Matching closest Lat and Lon
Hello, I have two tables. Both have Lat and Lon values in them along with other data. For each row in table A I need to find the index of table B where the Lat and Lon is the closest. I have a formula for working out the distance but I don't know how to incorperate it into a match type...- raven_squire
- Thread
- closest formula lat lon table
- Replies: 1
- Forum: Excel Questions
-
Y
fencing from a collection of coordinates
Hi, i have a list of coordinates (lat/LON decimal format wgs84) and i would like to find the extremity or perimeter points, i.e. to find the point that will define a polygon ignoring the inner points. Yossi- YEZ_1971
- Thread
- coordinates lat lon polygon
- Replies: 3
- Forum: Excel Questions
