Measuring distance between Lat / Lon (Decimal Degrees) coordinates in Excel

[ollyhughes1982]

Hi,

Has anyone managed to successfully measure distance between Lat / Lon (Decimal Degrees) coordinates in Excel?

I was given the below example by someone, but I can’t seem to get it work:

=6371*(ACOS(SIN(K$2*PI()/180)*SIN(C2*PI()/180) + COS(K$2*PI()/180)*COS(C2*PI()/180)*COS((J$2-B2)*PI()/180)))
Key:
Home parkrun = Lat: J$2 / Lon: K$2
Comparison parkrun = Lat: B2 / Lon: C2

I have attempted this with my data (highlighted this in yellow in my worksheet) where I’m trying to measure the distance between my home parkrun (Coed Cefn-pwll-du) and my nearest run I haven’t completed yet (Trelai Park parkrun). I know the distance should approximately be 14K. - I think this is as the crow flies.

My file is here: My parkrun Record - GEOGRAPHY.xlsx

Thanks!

 

[Lukasier]

Latitude and Longitude in Excel: Calculate Distance, Convert Degrees, and Geocode Addresses - BatchGeo Blog

If you have a long list of geographic coordinates to work with, a Microsoft Excel spreadsheet is sure to be useful. There are three basic Excel tools that can work for you, no matter how you want to manipulate your geographic coordinates. You’ll need to know how to calculate the distance between...

blog.batchgeo.com

 

[ollyhughes1982]

Thanks ??