Excel 2007 : Ignoring blanks with array formula?

Heyyo,

I'm currently using an array formula to search through a table for multiple instances of one criterion and return text from another column:

PHP Code: 

{=IFERROR(INDEX(GrandTab,SMALL(IF(COUNTIF($C$4,INDEX(GrandTab,,1,1))>0,ROW(GrandTab)-MIN(ROW(GrandTab))+1),ROW(A7)),10),"")} 


Where C4 is my criterion, and it looks through GrandTab to find all matching data, then returns lists of text from column 10. My problem is that many cells matching C4 have blank values in column 10, and I need to skip over those, so I get a solid list of text returns back from column 10 without a load of blanks in between.

I've seen "<>" included to do this somehow, but I'm not sure how it works and where to use it.

Any help you guys can offer would be greatly appreciated, thanks!