Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to set up a spreadsheet where I can track driver arrival times to
figure the individual driver round-trip turn-around time. Normally, there will be 3 or 4 drivers arriving before same driver arrives again. Some cases, however, driver will arrive again with only 1 driver since last arrival. =B19-INDIRECT(ADDRESS(ROW(C19)-6+MATCH(C19,C14:C18,0),2)) Works with 4 or 5 drivers hauling from same farm. I need a formula that will work if only 2 drivers are coming from the farm, but same formula needs to find correct arrival time if 4 or 5 drivers are coming from same farm. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a linked cell | Links and Linking in Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |