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

How do I calculate the distace between two GPS coordinates? 4
How do I calculate running pace? 1
circular reference where sumif and vlookup overlap 9
Help using two different values in a lookup table 1
Distance Calculations - Is there an easier way. 1
Get chart coordinate 3
To calculate a table of a function of two variables. 8
How do I add and subtract engineering stations in Excel? 3

Top