Find min() value greater than zero in column of numbers

  • Thread starter Thread starter 82716
  • Start date Start date
8

82716

I'm trying to find a formula that will find the min of a column of numbers
but not include a zero if that is the lowest. I got the min part, but if a
zero is there, that is my result. (in Excel 2003). Thx
 
Use your formula like this...

=SMALL(A:B,COUNTIF(A:B,0)+1)

Change the cell reference A:B to your desired range, if required.

Remember to Click Yes, if this post helps!
 
Another way
Placed in say, B2, array-entered*: =MIN(IF(A2:A100>0,A2:A100))
*press CTRL+SHIFT+ENTER to confirm the formula
Success? hit the YES below
 
Back
Top