Hi Greg
One way
Assuming your data is in column A, create a helper column (I used column
B) with the formula
=IF(COUNTIF($A$1:A1,A1)1,"",A1)
copy down column B for the extent of your data
In C1, enter
=SMALL(B:B<ROW())
Copy down column C and you will see the smallest, 2nd smallest etc.

--
Regards

Roger Govier


"Greg" wrote in message
...
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.