MIN IF >0

B

Bruce

I want to find the Min value of a range that is greater than 0.

Min (A1:A5) but ingore zero values.

Bruce
 
M

Max

One way ..

Try: =MIN(IF(A1:A5>0,A1:A5))
Array-enter the formula,
i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER
 
Top