Minimum from list that is not a zero

[mpeters]

I am trying to obtain the smallest value that is not a zero in a list.

e.g.

0.19 0.26 0 2.3 0 3.4

I would like to get the result to be 0.19 instead of 0.

I have tried:
{=IF(AJ2:AP2<>0,MIN(AJ2:AP2)," ")}

but, it is not working.

Any suggestions?

Thanks!

 

[Domenic]

Try...

=MIN(IF(AJ2:AP2,AJ2:AP2))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

 

[indiantrix]

Here is a solution that doesn't require the CSE key combo...
=SMALL(AJ2:AP2,COUNTIF(AJ2:AP2,0)+1)
HTH.../s/ Larry

 

[Richard Schollar]

Larry - that's clever. I like it!

Richard