CODEWITHSUNDEEP
excelms-office
Abhij
Abhij

Reputation: 1272

Find the distance between two given points using lat-long in Microsoft Excel

I have some 20 lat-long combination and I want to find distance of these 20 with 1000 other lat-long.
Does anybody have an Idea how can we do it using Excel.
Is it possible?
I can do it in Java but I just need the data so I want to do it in Excel...

Upvotes: 0

Views: 746

Answers (2)

Jerry Beaucaire
Jerry Beaucaire

Reputation: 3197

You may find the extended reading on this site educational on this topic:

http://www.cpearson.com/excel/LatLong.aspx

Upvotes: 1

NIVESH SENGAR
NIVESH SENGAR

Reputation: 1333

U can use following formula.........

=ACOS(COS(RADIANS(90-A2)) *COS(RADIANS(90-A3)) +SIN(RADIANS(90-A2)) *SIN(RADIANS(90-A3)) *COS(RADIANS(B2-B3))) *6371

Upvotes: 0

Related Questions