tag:blogger.com,1999:blog-6939412.post7480362536416711142..comments2023-05-20T00:38:12.847+10:00Comments on BlueMM: Excel formula to calculate distance between 2 latitude, longitude (lat/lon) points (GPS positions)BlueMMhttp://www.blogger.com/profile/08352276248902444098noreply@blogger.comBlogger339125tag:blogger.com,1999:blog-6939412.post-40723398035641638812019-05-30T03:38:49.489+10:002019-05-30T03:38:49.489+10:00You have my vote for president of america :)You have my vote for president of america :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-53114655070676461812019-05-20T01:44:34.937+10:002019-05-20T01:44:34.937+10:00Miles Gracias por este post! + de 10 años después ...Miles Gracias por este post! + de 10 años después y me es de gran ayudaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-39991850089035327052019-05-20T01:33:08.754+10:002019-05-20T01:33:08.754+10:00Muchísimas gracias !!! te escribo +10 años despu...Muchísimas gracias !!! te escribo +10 años después de tu post y me resultó muy útil.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-86712870512210631452019-05-17T04:19:51.233+10:002019-05-17T04:19:51.233+10:00Life. Saver.Life. Saver.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-82214232830402389782019-05-16T01:02:46.908+10:002019-05-16T01:02:46.908+10:00This formula is accurate. Its result perfectly mat...This formula is accurate. Its result perfectly matches the direct site survey result. Thank you so much!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-50772658878500864252019-05-02T19:32:29.441+10:002019-05-02T19:32:29.441+10:002019 and this blog post is still relevant. Well do...2019 and this blog post is still relevant. Well done, you nailed it. Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-76265529228366256042019-04-26T06:29:31.559+10:002019-04-26T06:29:31.559+10:00Maaaaan, it's 2019 and I'm from Brazil... ...Maaaaan, it's 2019 and I'm from Brazil... But THANKS!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-32439943894300307822019-03-28T18:45:17.433+11:002019-03-28T18:45:17.433+11:00Thank you in 2019!!!Thank you in 2019!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-43827011940523173882019-02-21T09:59:07.119+11:002019-02-21T09:59:07.119+11:0010 years later, still a superstar!!!! thank you! ...10 years later, still a superstar!!!! thank you! :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-89394910753415049532019-02-08T17:16:21.932+11:002019-02-08T17:16:21.932+11:00Simply Brilliant. Thanks
Simply Brilliant. Thanks<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-60585034166208730772019-02-01T18:21:02.923+11:002019-02-01T18:21:02.923+11:00Just Awesome!! You helped a lot..
One request.......Just Awesome!! You helped a lot..<br /><br />One request....could you please share excel formula to calculate orientation between two points in degrees...??<br /><br /><br />Thanks in advance.... :)Anonymoushttps://www.blogger.com/profile/05497199802073936915noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-84930509343351239012019-01-31T07:44:03.444+11:002019-01-31T07:44:03.444+11:00What format do you enter Lat / Long into cells and...What format do you enter Lat / Long into cells and what format do you use for the cell (number, general, custom, etc) for your calculation to work? ThanksAnonymoushttps://www.blogger.com/profile/11720725632876892606noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-27636141205384820252018-10-24T00:47:08.634+11:002018-10-24T00:47:08.634+11:00GENIUS!!!!! Exactly what I was looking for. THAN...GENIUS!!!!! Exactly what I was looking for. THANKS!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-10509959477233747192018-09-28T00:30:35.132+10:002018-09-28T00:30:35.132+10:00Great work thank you for the effort this is the on...Great work thank you for the effort this is the only excel formula that I could find to work.Anonymoushttps://www.blogger.com/profile/17190639561380745006noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-56649351568071098432018-09-06T18:21:06.914+10:002018-09-06T18:21:06.914+10:00Thanks for such a helpThanks for such a helpVatanhttp://www.twicerr.comnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-63170601216236926392018-08-08T06:54:08.730+10:002018-08-08T06:54:08.730+10:00To be thanked, to be commended.To be thanked, to be commended.Anonymoushttps://www.blogger.com/profile/04487574293471850518noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-44706614657424997502018-08-03T03:45:20.199+10:002018-08-03T03:45:20.199+10:00Thank you...Really helpful...Thank you...Really helpful...Ramnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-92217933850623174902018-07-28T00:49:45.373+10:002018-07-28T00:49:45.373+10:00Thank you, thank you! It's been over four year...Thank you, thank you! It's been over four years since the last comment (almost exactly 11 years since original post), but I agree with previous posts that I couldn't just use your info and leave! V cool how many people you've helped, and the info is still relevant now - granted I'm currently still on Office 2013 so...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-66164104055473557732018-07-24T04:15:23.309+10:002018-07-24T04:15:23.309+10:00Mad props Sir!Mad props Sir!Anonymoushttps://www.blogger.com/profile/13667754599140644011noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-4400057443612487572018-06-26T14:04:37.263+10:002018-06-26T14:04:37.263+10:00Thank you, this formula saved me so much work.Thank you, this formula saved me so much work.Brad Hawkinshttps://www.blogger.com/profile/03356788437446702575noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-60426281271377801272018-06-21T22:46:50.967+10:002018-06-21T22:46:50.967+10:00Bless you!
You saved my day.Bless you!<br />You saved my day.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-35490599744201063022018-06-21T22:45:47.789+10:002018-06-21T22:45:47.789+10:00Bless you!.
Saved my day.Bless you!.<br />Saved my day.Anonymoushttps://www.blogger.com/profile/03045346680668340220noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-29842804684277128082018-06-17T22:47:08.685+10:002018-06-17T22:47:08.685+10:00Note precise distance calculation on ellipsoid sur...Note precise distance calculation on ellipsoid surface requires way more complicated approach. Vincenty formulae is one of the solutions. For Excel implementation see https://github.com/tdjastrzebski/VincentyExcelAnonymoushttps://www.blogger.com/profile/11644420643233619383noreply@blogger.comtag:blogger.com,1999:blog-6939412.post-13889160359744067472018-06-01T19:16:14.211+10:002018-06-01T19:16:14.211+10:00Cheers guys... years later this is still fab!Cheers guys... years later this is still fab!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6939412.post-14655807490171661232018-05-30T13:34:17.143+10:002018-05-30T13:34:17.143+10:00Thanks man! it is very helpful!Thanks man! it is very helpful!Anonymoushttps://www.blogger.com/profile/09846723814860721461noreply@blogger.com