It works as I understand the data.
Explain what the data looks like now, or the possible combination, what
formulae you have where, and how it doesn't work.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"cjjoo" wrote in message
...
but what sohuld i do if x123 comes back into the workshop more than two
times
in a single day ? (date in and date out)
the formula does not seems to work . hope that you can give me some
advise . tks
the key thing is that once a vehicle has been dated out , the next time
it comes
into the workshop, a different ID will be issued and the vehicle will
be using the
new id until it is dated_out again.
complicated?
--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=477417