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

E

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
 
S

SteveG

Eric,

If your list is A1:A10

=SMALL(A1:A10,2)

This gives the second smallest number in the range.

Cheers,

Steve
 
D

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
 
Top