Another question

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.

cmart02
Fri May 09 07:26:02 CDT 2008

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
Fri May 09 07:39:01 CDT 2008

Hi Robert,

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

"jimmy" wrote:

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

Ron
Fri May 09 07:40:48 CDT 2008

On Fri, 9 May 2008 05:20:01 -0700, jimmy <jimmy@discussions.microsoft.com>
wrote:

>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

cmart02
Fri May 09 07:48:00 CDT 2008

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/