|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 13th, 2010, 07:16 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate Track and Distance from two sets of coordinate
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. 
|
|
#2
February 13th, 2010, 07:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I calculate Track and Distance from two sets of coordinate
Excel 2007
GPS Start, stop names, coordinates Drop-downs Distance, bearing, map http://www.mediafire.com/file/wyyyqjxjdt2/02_13_10.xlsx
|
|
#3
February 14th, 2010, 03:10 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I calculate Track and Distance from two sets of coordin
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 "Herbert Seidenberg" wrote: Excel 2007 GPS Start, stop names, coordinates Drop-downs Distance, bearing, map http://www.mediafire.com/file/wyyyqjxjdt2/02_13_10.xlsx .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
