G Guest Dec 23, 2004 #1 I want to find the Min value of a range that is greater than 0. Min (A1:A5) but ingore zero values. Bruce
I want to find the Min value of a range that is greater than 0. Min (A1:A5) but ingore zero values. Bruce
M Max Dec 23, 2004 #2 One way .. Try: =MIN(IF(A1:A5>0,A1:A5)) Array-enter the formula, i.e. press CTRL+SHIFT+ENTER instead of just pressing ENTER
One way .. Try: =MIN(IF(A1:A5>0,A1:A5)) Array-enter the formula, i.e. press CTRL+SHIFT+ENTER instead of just pressing ENTER
