MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

=============