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