minimum function
 

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

minimum function
 

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

minimum function
 

Hello cutyfurby,

You need an array formula:

=MIN(IF(E1:E50,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

minimum function
 

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" wrote
in message ...

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