Hi!

that have not been closed (column B)

Does that mean the text "Closed" may or may not be in column B?

Try this:

Array entered using the key combo of CTRL,SHIFT,ENTER:

=SMALL(IF((Overall!B$2:B$20<"closed")*(Overall!S$ 2:S$20<"repair
clin"),Overall!O$2:O$20),ROWS($1:1))

Copy down 10 rows.

Biff

"roy.okinawa" wrote in message
...
I need a formula on my "Problem Areas" sheet that will search and then list
from my "Overall" sheet the ten oldest dates (column O), that have not
been
closed (column B), and do not match the text "Repair Clin" (column S).
Each
row of data begins with the purchase order# (column A).

On the "Problem Areas" sheet it will only list the PO# and Date Opened.