What function to determine the second small integer from a list?

[Eric]

I get a list of integers, and would like to determine which one is the second
small integers from the list. Does anyone know what function to perform the
above task?
Thank for any suggestion
Eric

[SteveG]

Eric,

If your list is A1:A10

=SMALL(A1:A10,2)

This gives the second smallest number in the range.

Cheers,

Steve

[Duke Carey]

=Small(list,2)

If the number that is the smallest in the list appears twice or more, you'll
get the that number


"Eric" wrote:

> I get a list of integers, and would like to determine which one is the second
> small integers from the list. Does anyone know what function to perform the
> above task?
> Thank for any suggestion
> Eric

[Eric]

Thank everyone, This is perfect for my needs