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

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

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

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!

--------------------
(Ms-Exl-Learner)
--------------------


"82716" wrote:

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

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

Another way
Placed in say, B2, array-entered*: =MIN(IF(A2:A1000,A2:A100))
*press CTRL+SHIFT+ENTER to confirm the formula
Success? hit the YES below
--
Max
Singapore
xde
---
"82716" wrote:
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