calculating the minimum value ignoring o

J

jo jo

How do I calculate the minimum figure but ignoring and 0 values

For example:

8
0
5
8
0
2
4
0
3
7
8
the I looking for is 2
 
A

Aladin Akyurek

If no negative entries in the range of interest:

=SMALL(Range,COUNTIF(Range,0)+1)

Otherwise:

=MIN(IF(Range,Range))

which must be confirmed with control+shift+enter, not just with enter.
 
Top