Assuming the numbers are all positive: =SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
T T. Valko Mar 18, 2010 #21 Assuming the numbers are all positive: =SMALL(A1:A10,COUNTIF(A1:A10,0)+1)