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
Bookmarks