MIN function
Posted by Rob on December 14, 2001 6:37 AM
How can I get a MIN value in a specified range without counting the zero values in that range???
Posted by Aladin Akyurek on December 14, 2001 6:44 AM
Rob --
Array-enter
=MIN(IF(A1:A10,A1:A10))
To array enter a formula, you need to press control+shift+enter, not just enter.
Aladin
=============
