Assuming the data occupies rows 2:100, try this array formula (entered with
CTRL+SHIFT+ENTER):

=SMALL(IF(F2:F100="",100000,A2:A100),2)

100000 corresponds to a date in the year 2173, so empty dates in column F are
treated as being filled in 2173.

On Thu, 17 Feb 2005 23:55:04 GMT, "Alan Anderson via OfficeKB.com"
wrote:

My worksheet has Date.Ordered in COL-A and Date.Filled in COL-F. I can
find the oldest date in Date.Ordered by using the SMALL function. However,
when I fill that order, I need to know the next oldest date to be filled.
I cannot figure out how to make the formula look at only unfilled orders
(i.e where a date does not exist in Date.Filled).

Does anyone have a solution?