2nd lowest Value in Array
 

I need to return the 2nd lowest value in a contiguous number array but I want
to exclude zero values, how can I write this formula?

2nd lowest Value in Array
 

One way

=SMALL(IF(A1:A10<0,A1:A10),2)

needs to be entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom


"Dale" wrote in message
...
I need to return the 2nd lowest value in a contiguous number array but I
want
to exclude zero values, how can I write this formula?

2nd lowest Value in Array
 

"Peo Sjoblom" wrote...
One way

=SMALL(IF(A1:A10<0,A1:A10),2)

needs to be entered with ctrl + shift & enter

Standard quibble: condition should be 0. If negative and positive
values are 'valid', zero values should be as well.

Anyway, this could be done without array formulas using

=SMALL(A1:A10,COUNTIF(A1:A10,"<=0")+2)