Hi Pete,
Just follow the following steps hope this will work for you.
i pasted the data in A1 to B7 as
Balloons 01/01/2013
Cards 01/01/2013
Balloons 01/01/2013
Balloons 02/01/2013
Cards 03/01/2013
Balloons 03/01/2013
Streamers 03/01/2013
then in G2 i pa
I think the output would containd three values Cards, Ballons, Streamers
and for this output below is the formula. Confirm it with CSE
*
=IFERROR(INDEX($A$1:$A$8,SMALL(IF(((VALUE($B$2:$B$8)>=VALUE($D$1))*ROW($A$2:$A$8))=0,"",((VALUE($B$2:$B$8)>=VALUE($D$1))*ROW($A$2:$A$8))),ROW($A$1:$A$8))),"")
*
