Another question

J

jimmy

Hello all,

I have another question.

How to have the minimum value of a column that not includes the 0.
I´m trying MIN(B5:B10)... but, the formula returns the 0.

Well, thanks for your attention.

P.S. By the way, thanks for all the good answers.
 
J

jimmy

Hi Robert,

Thank you for the answer.
But i´m not making this work. Is there any other way?
Thanks
 
R

Ron Rosenfeld

Hello all,

I have another question.

How to have the minimum value of a column that not includes the 0.
I´m trying MIN(B5:B10)... but, the formula returns the 0.

Well, thanks for your attention.

P.S. By the way, thanks for all the good answers.
Click to expand...

Array-enter this formula:

=MIN(IF(B5:B10<>0,B5:B10))

To array-enter a formula, hold down <ctrl><shift> while hitting <enter>. Excel
will place braces {...} around the formula
--ron
 
Top