How do I calculate Track and Distance from two sets of coordinate

A

Ant

I have a table of place names and gps coordinates. Via drop down boxes and
vlookup, a user can select a start point and destination. I would like excel
to then calculate the Track and Distance from the start point to the
destination. How is this calculation made please??. I could find no function
within Excel to do this, but I have seen a spreadsheet that does it,
unfortunately the workbook was protected.
 
A

Ant

Thank you Herbert. Exactly what I was looking for, but delving into the
bowels of the workings shows how complicated it is.

I think it is easier to copy your worksheet to my file and design my form
around your worksheet. Hope this is ok with you.

A very helpful website that will come in handy with some of my flight
planning in future.

Regards
Ant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distance between latitude and longitude 1
hot to calculate peaks of an "irregular" sine wave 1
Calculating the distance customers live from a branch office 5
How do I calculate the distace between two GPS coordinates? 4
Which function? Biggest distance to the Nearest city ... 9
Excel Countif Function - Calculating Between Two Sets of Values 3
Excel Solver constraints 1
Plotting time and distance vs moon phase... 1

Top