Find smallest number that is not zero

[fernipascual]

Hi again. How do I find the smallest number in a list that is not zero, especially if I have multiple rows with zero values.

I tried SMALL(range,2) but still got zero.

thanks

 

[VoG]

Try

=MIN(IF(A1:A10<>0,A1:A10))

confirmed with CTRL + Shift + Enter, not just Enter.

 

[Jonmo1]

Try

=MIN(IF(range<>0,range))

IMPORTANT:
This is an array formula Enterd with CTRL + SHIFT + ENTER

 

[Aladin Akyurek]

Hi again. How do I find the smallest number in a list that is not zero, especially if I have multiple rows with zero values.

I tried SMALL(range,2) but still got zero.

thanks

I suspect that you mean the smallest non-zero positive number...

Just enter:

=SMALL(Range,COUNTIF(Range,"<=0")+1)

Or control+shift+enter, not just enter:

=MIN(IF(Range>0,Range))

 

[fernipascual]

Great, thanks again for your help!

 

[Aladin Akyurek]

Great, thanks again for your help!

Thanks for providing us feedback.