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 |
All times are GMT +1. The time now is 05:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com