Not sure I understand the question.

If you had integers in A1:A50 for example, then in B1 you put in the formula

=Small($A$1:$A$50,row())

and drag filled it down the column, it would give you a sorted list from
smallest to largest.

--
Regards,
Tom Ogilvy

"jase" wrote in message
oups.com...
Hi Tom,

if this said "=small(range,x)" then would there be a function that
could return the x value for a list of integers e.g =rank(range) ? or
would I have to come up with a UDF ?

Regards,
Jason Q

Tom Ogilvy wrote:
=small(range,2)

--
Regards,
Tom Ogilvy

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