Get rid of empty cells while using formula

Originally Posted by Bob Phillips

Try

=IF(ISERROR(SMALL(IF($B$3:$B$13=$L$1,ROW($B$3:$B$13)),ROW(A1))),"",
INDEX($A$3:$A$13,SMALL(IF($B$3:$B$13=$L$1,ROW($B$3:$B$13)),ROW(A1))-MIN(ROW($A$3:$A$13))+1))

i am putting your formula in F3 and drag it down but it gives answer for first (F3) and other are nothing but blank cells.

hy! Thanks for the kind help, but i need more PLEASE PLEASE PLEASE....

Did you array-enter it, Ctrl-Shift-Enter?