Using MIN function but eliminating 0's

[Top_Hat]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to find the minimum number greater then 0 in a column of numbers. Using MIN (=min(a1:a3) in a column with 2, 5, 0 as the data, MIN returns "0" but I want it to return "2" by ignoring the 0's.

Thank you for any help.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to find the minimum number greater then 0 in a column of numbers.
Using MIN (=min(a1:a3) in a column with 2, 5, 0 as the data, MIN returns "0"
but I want it to return "2" by ignoring the 0's.

One way (array-entered using CMD-RETURN):

=MIN(IF(A1:A3>0,A1:A3))

 

[Carl Witthoft]

One way (array-entered using CMD-RETURN):

=MIN(IF(A1:A3>0,A1:A3))

should be a lot easier: =SMALL(a1:a3,2) ; this will only work if 0 is
the minimum value you ever have in your data set.

 

[Carl Witthoft]

One way (array-entered using CMD-RETURN):

=MIN(IF(A1:A3>0,A1:A3))

Sorry --- ignore my post about SMALL. The documentation (at least for
Office2004) is misleading; SMALL doesn't comprehend repeated values.

So, use this:

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