Hey Biff,
Thanks for the response. For some reason I couldn't get your formula to
work for me the way you have it set up. I ended using an older formula I
had in another worksheet. It is a combination of two formulas.

First (not an array):
=SUMPRODUCT(--(Data!$E$2:$E$500<0),--(Data!$E$2:$E$500<""))

And then I would use the second formula based on the first.
Second (array formula):
{=IF(ROWS(B$32:B32)<=$I$32,INDEX(Data!$A$2:$A$500, SMALL(IF((Data!$E$2:$E$500<0)*(Data!$E$2:$E$500< ""),ROW(Data!$E$2:$E$500)-ROW(Data!$E$2)+1),ROWS(B$32:B32))),"")}

I couldn't understand (in your formula) what the ROW($1:$14) was used
for. Unless you were displaying the smallest 14 values...??? But oh
well, I got it to work anyway :)

Thanks again for the response Biff


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=395491