Need a little help please
See attached sample. I have my lists of routes and their associated junctions and distances on the 'Lists' worksheet.
On the 'Database' work sheet:
1. Column A is to have a drop down list for the Routes
2. Columns B & C are to have drop down lists for the junctions based on the route selected in Column A
3. Column D is to have an automated formula showing the distance between the selected junctions
I have shown an example on the attached.
Also, i need to know how to show only positive values on Column D, in the event that it results in a negative value (as i could be travelling in the other direction).
Please bear in mind I do not have Kutools. Do I need it to do this?
Thanks a mill
Bookmarks