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?

--
Message posted via http://www.officekb.com