One way would be to use a helper column, with your data in column A,
in B1 put =A1
in B2 put =IF(A2=A1,"",A2) and copy down........
in C1 put =SMALL(B:B,2)

hth
Vaya con Dios,
Chuck, CABGx3



"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.