"roy.okinawa" wrote
I have done the first step on the Overall sheet
and get dates on cells in column S
that do not have Repair Clin, they are blank.

Roy,

Don't think there's anything wrong with your observation above (wrt what
appears in col T), if I've interp'd your criteria correctly. Don't worry
what appears in col T, look more at the results extracted in "Problem Areas"
sheet. I've provided the sample earlier to illustrate. Are they correct ?

Col T in "Overall" is a criteria col with an arbitrary tie-breaker built-in
to differentiate any lines with duplicate dates in col O satisfying the
criteria which might arise. The criteria used was framed based on your orig.
post's specs:

.. from my "Overall" sheet
dates (column O), that have not been closed (column B),
and do not match the text "Repair Clin" (column S)

I made 2 key accompanying assumptions: (1) that the indication in col B to
pick up was "Closed", and (2) that there might be POs with duplicate dates
which satisfy the criteria you stated, hence requiring a tie-breaker.

Did you get the correct results when you adapted the formulas to suit your
actual sheet? Col T's criteria capture could be re-tweaked if the results
returned are somehow not consistent with what you really want. Pl feedback
...

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