minimum function

[cutyfurby]

How to find the minimum value in the range exclude zero.

[Ken Johnson]

Hi cutyfurby,
this array formula worked for me to return the minimum of A1:A10...

=MINA(IF(A1:A10=0,"",A1:A10))

after typing the formula you must commit it using Ctrl + Shift + Enter

Ken Johnson

[JudithJubilee]

Hello cutyfurby,

You need an array formula:

=MIN(IF(E1:E5>0,E1:E5))

You will need to press Ctrl+Shift+Enter to confirm the formula not just Enter

Judith
--
Hope this helps


"cutyfurby" wrote:

>
> How to find the minimum value in the range exclude zero.
>
>
> --
> cutyfurby
> ------------------------------------------------------------------------
> cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371
> View this thread: http://www.excelforum.com/showthread...hreadid=521326
>
>

[Biff]

>How to find the minimum value in the range exclude zero.

=MIN(IF(A1:A10<>0,A1:A10))

Entered as an array using the key combo of CTRL,SHIFT,ENTER.

Biff

"cutyfurby" <[email protected]> wrote
in message news:[email protected]...
>
> How to find the minimum value in the range exclude zero.
>
>
> --
> cutyfurby
> ------------------------------------------------------------------------
> cutyfurby's Profile:
> http://www.excelforum.com/member.php...o&userid=32371
> View this thread: http://www.excelforum.com/showthread...hreadid=521326
>