Another question

[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.

 

[Robert Martim, Excel]

You can do as follows:

=IF(MIN(IF(B5:B10<>0,B5:B10))=0, "No minimum value to display",
MIN(IF(B5:B10<>0,B5:B10)))

Press CTRL+SHIFT+ENTER when you finish.

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

 

[jimmy]

Hi Robert,

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

 

[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.

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

 

[Robert Martim, Excel]

Jimmy

WHen you type the last parenthesis you will need to press (all together) the
keys CTRL+SHIFT+ENTER instead of ENTER alone...

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/