smallest number not zero

[Neuther]

Is there a function that i can use to find the smallest number in an array but not enclused 0.

I tried =Small(A1:A25,2)

but i have multiple zero's and it still picks zero.

I'm not great w/ vb but i can do a little if i need to.

[JBeaucaire]

A long way to go for it, but this does it.

=SMALL(A1:A25,COUNT(A1:A25)-COUNTIF(A1:A25,"=0")-1)

[NBVC]

=Min(IF(A1:A25<>0,A1:A25))

confirmed with CTRL+SHIFT+ENTER not just ENTER

[daddylonglegs]

I assume you have only positive numbers or zero....try either

=SMALL(A1:A25,COUNTIF(A1:A25,0)+1)

or an array formula

=MIN(IF(A1:A25,A1:A25))

confirmed with CTRL+SHIFT+ENTER

[Ron Coderre]

Try something like this for the smallest non-zero number:

Please Login or Register  to view this content.

for the 2nd smallest:

Please Login or Register  to view this content.

Does that help?