Hello all,
I am using an array to determine the minimum value in a range, where not
equal to 0:
S26 : {MIN(IF(T26:T40 <> 0, T26:T40))}

I want to use another array to dermine the same thing for a different
range.

S45: {MIN(IF(T45:T59 <> 0, T45:T59))}

There is conditional formatting on each of these ranges to change pattern
and font based on seperate cells. When I added the 2nd array above to S45,
not only did it not ignore the zeroes, but it also caused the T26:T40 range
to change font and pattern.

I am very confused by this, since the array in S45 has nothing to do with
the range T26: T40 and the conditional formatting in range T26:T40 has
nothing to do with S45.

Any suggestions would be greatly appreciated,
Renee