"roy.okinawa" wrote
As I looked through my earlier posts,
I see that I didn't clarify that there
may be more text along with Repair Clin in Column S.
Repair Clin will always come first followed
by a period and then, if any, the remaining text.

As posted in the other branch,
changing this check on col S:

... S2<"Repair Clin" ..
to
... NOT(ISNUMBER(SEARCH("Repair Clin",S2))) ...

should now be enough as the refined criteria,
viz.:

In sheet: Overall
--------------------
Put instead in T2, and copy down:
=IF(O2="","",IF(AND(TRIM(B2)<"Closed",NOT(ISNUMBE R(SEARCH("Repair
Clin",S2)))),
O2+ROW()/10^10,""))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--