|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
TEN OLDEST DATES
That did it.
Thank you very much.
"Max" wrote:
"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
--
|