Assuming that A2:A10 contains the data, try the following...

For the second lowest unique number...

=SMALL(IF(A2:A10<"",IF(MATCH(A2:A10,A2:A10,0)=ROW (A2:A10)-ROW(A2)+1,A2:A
10)),2)

....confirmed with CONTROL+SHIFT+ENTER.

To return a list of unique numbers, lowest to highest...

B2:

=MIN(A2:A10)

B3, copied down:

=MIN(IF($A$2:$A$10B2,$A$2:$A$10))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Greg wrote:

I have a simple array, just 1 column.
But various numbers are listed multiple times.
using =SMALL(ARRAY,2) or =SMALL(ARRAY,3) or =SMALL(ARRAY,4)
all yield the same number.
Obviously =SMALL will yield the 2nd number as in a sequence of all numbers
in the array, it does not yield the 2nd Smallest or Lowest number.