If your input array is in A21:H21,
should return the smallest positive value (or "NA") if there isn't one. The
logic is to count the number of positive values, and use that as an argument
to the LARGE function. --Bruce
> I have an array that is 1 row high by
16 columns wide.
> Each cell may contain a positive value, or a zero.
> I need a formula to find the "Minimum value that is greater than zero" in
> columns 1,3,5,7,9,11,13 and 15.
> =MIN(A1,C1,E1,G1,I1,K1,M1,O1) will always return the zero value while I
> need the minimum value that is greater than zero.
> If I use nested IF functions to exclude zeroes I run foul of the max of 7
> I would greatly appreciate any help and thank you in advance for any offered.