View Single Post
  #1   Report Post  
rcmodelr
 
Posts: n/a
Default Finding last cell to contain same value as current cell?

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.