It will take two cells, but here is how to do it.

In a helper cell, E18, type this formula.

="A"&COUNTIF(A:A,"<0")-1


Then in the cell where you want your answer, type

=MIN(A1:INDIRECT(E18))


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=497216