Hi

how is the worksheet set up (ie what column has driver name / number) what
column has depart & arrive times?

Cheers
JulieD

"rcmodelr" wrote in message
...
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.