Forum Discussion
EXCEL FORMULA HELP
Hello ALL .....Please help!
Please find attached an excel.
SHEET 1: Is the data showing the KMS taken to go from Point A to Point B. This is my source data sheet and will be const...
Hello Haytham,
Thank you very much!
Now, in a scenario where the Column A is not constant (Please refer to the attached sheet, DATA, Row 5,6,7). How will that formula change on the next sheet?
Thank you again for your help!
In this case, you have to use an array formula to take into account the pick up location.
Please find the solution in the attached file.
- Yes...this looks perfect.
Just one small addition...in the Driver Sheet, you had initially made Column E as a drop down option? Can you do the same for Column D ?Yes of course, please find the attached file!
I've used something called: https://support.office.com/en-us/article/Apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249, and it's one of the essential features in Excel, so I advise you to learn it.