minimum

[Neil]

I need to find a minimum value, but not including any
values of zero.

 

[J.E. McGimpsey]

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).

 

[Paul]

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.