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

=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

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

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

Hi Tom
Sorry my question is a bit unclear.
If you have the following list anywhere on a sheet

10
60
5
100
2

Lets say they are in cells F6:F10, then I was wondering if there is a
function which when put in cells G6:G10 will return

3
2
4
1
5

i.e it will put the rank in the cell 100 being the highest number, in
cell F9, therefore the function puts 1 in G9 - or is the only way
forward a UDF?

Thanks
J

Tom Ogilvy wrote:
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

Thank everyone, This is perfect for my needs