Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array Question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function Question | Excel Worksheet Functions | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) | |||
Array Function Question | Excel Worksheet Functions | |||
Multicell Array Formula and List Question | Excel Worksheet Functions | |||
SUM array formula question | Excel Worksheet Functions |