Dates lookup - part 2

[gilbert]

Gee...anybody can give me an indication / idea how to go abou
this...the Excel workbook is enclose herewith...

Basically, I am looking toward how do we ask excel to match all dat
incurred after certain dates into one? See the enclose workbook fo
your understanding

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=43999

 

[Frank Kabel]

Hi
enter the following array formula in T8 of your spreadsheet (entered
with CTRL+SHIFT+ENTER):
=INDEX($B$3:$B$100,SMALL(IF($C$3:$C$100>DATE(2004,4,15),ROW($C$3:$C$100
),1000),ROW()-7)-2)
and copy down.

If you want to put this formula at a different location you have to
change the part ..ROW()-7.. accordingly. General notation:
...ROW()-row_formula_starts-1

Frank
P.S.: you should try to post your problem in plain text without
attaching files