Hi
Please see the files?
One for Array formula work all excel 2003-2013 and other is AGGREGATE work from 2010 onward not before.
I give you idea with this sample?
Array
Formula:
=IFERROR(INDEX(A$2:A$600, SMALL(IF($B$2:$B$600>1, IF($B$2:$B$600< TODAY(), ROW($B$2:$B$600)-1)),ROWS($A$1:A1))),"-")
Press same time CTRL+SHIFT+ENTER not just ENTER till you see like this {} then copy down
or you on excel 2013
Non Array
Formula:
=IFERROR(INDEX(A$2:A$600,AGGREGATE(15,6,ROW($A$2:$A$600)-ROW($A$2)+1/(($B$2:$B$600>1)/($B$2:$B$600< TODAY())),ROWS($A$1:A1))),"-")
Copy down
Bookmarks