Finding MIN value

[Liz Hansen]

Hi,

I need to find the MIN value in an array and I'm using MIN(A1:A12).

My problem is that there are cells within this range that has the value of 0
(zero) and in my case they need to be ignored. How do I modify the function
in order to just look at any number larger than 0 and then find the smallest
of those?

Thanks!

Liz

 

[NH]

Sy the value are within range b3:b6
=MIN(IF(B3:B6<>0,B3:B6," "))
Press ctrl-shift-enter

 

[Frank Kabel]

Hi
try the array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:A12<>0,A1:A12))

 

[Liz Hansen]

Thanks, this works!

Sy the value are within range b3:b6
=MIN(IF(B3:B6<>0,B3:B6," "))
Press ctrl-shift-enter


of