What happens if the result is 1 or 2?

COUNTIF(A:A,"<0")

If the result is 1:

=MIN(A1:INDIRECT(E18))

=MIN(A1:A0)

If the result is 2:

=MIN(A1:A1)

Biff

"rsenn" wrote in
message ...

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