View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ant Ant is offline
external usenet poster
 
Posts: 53
Default 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.