minimum

  • Thread starter Thread starter Neil
  • Start date Start date
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).
 
Neil said:
I need to find a minimum value, but not including any
values of zero.

For values in A1:A5:
=MIN(IF(A1:A5<>0,A1:A5))
Must array-enter: CTRL+SHIFT+ENTER rather than just ENTER.
 
Back
Top