thanks Max. i tried and i got the following:-
Date Items
2/4/2009 2 ABC
AEG
4 AEH
5

I just put one date in A2 and i got the results in b2:b4, even though i did
not enter any dates from A3 onwards.



"Max" wrote:

Easiest is to apply autofilter on the dates col in the source table & filter
out by the desired date.

If you wish to extract it directly in another sheet, try this simple
formulas play:
Asume source table as posted in Sheet1, cols A and B, data from row2 down
In another sheet,
Assume the date of interest will be input in A2
In B2: =IF(A$2="","",IF(Sheet1!B2=A$2,ROW(),""))
In C2:
=IF(ROWS($1:1)COUNT(B:B),"",INDEX(Sheet1!A:A,SMAL L(B:B,ROWS($1:1))))
Copy B2:C2 down to cover the max expected extent of source data.
Hide/minimize col B. Col C will return the required items.
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Meeru" wrote:
i have the following data:-

Items # Date
ABC 2/4/09
DEF 4/5/09
AEG 2/4/09

I want to auto extract items# when you enter a date, but i do have a
duplicate date how do i auto extract when there is a duplicate date:-

Date Items
2/4/09 ABC
2/4/09 AEG
thanks for your help
meeru