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

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

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

Eric,

If your list is A1:A10

=SMALL(A1:A10,2)

This gives the second smallest number in the range.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=496933

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

=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

What function to determine the second small integer from a lis
 

Thank everyone, This is perfect for my needs