I need to find a minimum value, but not including any values of zero.
J J.E. McGimpsey Oct 17, 2003 #2 one way (array entered: CTRL-SHIFT-ENTER or CMD-RETURN): =MIN(IF(rng=0,"",rng)) where rng is your range to look in (can't be entire rows or columns).
one way (array entered: CTRL-SHIFT-ENTER or CMD-RETURN): =MIN(IF(rng=0,"",rng)) where rng is your range to look in (can't be entire rows or columns).
P Paul Oct 17, 2003 #3 Neil said: I need to find a minimum value, but not including any values of zero. Click to expand... For values in A1:A5: =MIN(IF(A1:A5<>0,A1:A5)) Must array-enter: CTRL+SHIFT+ENTER rather than just ENTER.
Neil said: I need to find a minimum value, but not including any values of zero. Click to expand... For values in A1:A5: =MIN(IF(A1:A5<>0,A1:A5)) Must array-enter: CTRL+SHIFT+ENTER rather than just ENTER.
