sorry, mac, the results are indeed shown in col C and not in col B, it was my
typing error when i typed that results are shown in col B, i meant col C and
not col B.
In column A2, i only typed 2/4/2009 and i get the following :-
In column B1 to B4 i get 2,space,4,5
In column C1 to C4 i get ABC,AEG,AEH
thanks for your kind clarification.
"Max" wrote:
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.
Yes, of course. The results, btw are in col C, not col B. Col B is a helper
criteria col which can be hidden away (as mentioned in my response). Isn't
that how you wanted it extracted? The source item/multiple items
corresponding to that date input in A2 will be listed in col C, neatly
bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Meeru" wrote:
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.