=COUNTIF(A1:A4,"<="&0))
will give you the count of values less than or equal to 0.

So if you want to ignore those values, you could just look for the
(2 + that number) smallest:

=SMALL(A1:A4,2+COUNTIF(A1:A4,"<="&0))

I like this syntax:
=COUNTIF(A1:A4,"<="&0))
but you could use:
=COUNTIF(A1:A4,"<=0"))

But if you put that value in X99, the first is easier to modify:
=COUNTIF(A1:A4,"<="&x99))



On 06/06/2011 02:32, kittronald wrote:
How can you find the X smallest number in a range that is greater than
Y ?

For example, return the second smallest number in the range A1:A4 that
is greater than 0.

A
1 0
2 0
3 10
4 20

The result should be 20.

Any ideas ?


- Ronald K.

--
Dave Peterson