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

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
 
M

Ms-Exl-Learner

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!
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MIN function 5
Beep on greater than zero 1
Finding the MIN value, but greater than zero 2
How do I find the minimum value greater than zero 1
Min value excluding 0 and another criteria 5
Min function excluding zero 5
Pick the low number in a column of Numbers 3
How do I get the lowest number in a row to turn red in Excel ? 5

Top