PS: To get the 5 oldest files, you need 5 formulas, that differ with respect
to the last argument to SMALL: 1, 2, 3, 4, and 5, respectively.


"Alan Anderson via OfficeKB.com" wrote in message
...
Both of the above suggested formulas return "01/00/1900". Here is what
I'm
trying to do. On Sheet2 I have a summary which shows the:

I J
5 OLDEST FILES [ Formula in J1
1 11/19/04 DA127946 [ =LOOKUP(I1,Date.Ordered,Number)
2 11/30/04 DAA23052
3 12/03/04 DAA70412-5
4 12/06/04 DAB09503-5
5 12/10/04 8V001730

On Sheet1 I have the list:
A B F
1 DATE DATE
2 ORDERED NUMBER FILLED
3 11/19/2004 DA127946 12/10/04
4 11/30/2004 DAA23052
5 12/3/2004 DAA70412-5
6 12/6/2004 DAB09503-5 01/09/05
7 12/10/2004 DAA08872
8 12/11/2004 8V001730
9 12/15/2004 DAB11801
10 1/6/2005 DAA70654

Because F3 and F6 have dates, the order is filled. My five oldest files
(not yet filled) need to show:
1 11/30/2004
2 12/3/2004
3 12/10/2004
4 12/11/2004
5 12/15/2004

How do I get the SMALL function to see only the dates in COL-A that have a
corresponding empty cell in COL-F ??

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