I want to take a list of numbers and sort them using functions in another
column

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this make sence.

Enter this in C1, and copy down as needed:

=SMALL($A$1:$A$100,ROWS($1:1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"zoomzoom632" wrote in message
...
I want to take a list of numbers and sort them using functions in another
column

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this make sence.

Please don't multi-post - it fragments your answers and wastes
responders' time if you already have an answer elsewhere.

Pete

On Oct 12, 11:51 pm, zoomzoom632
wrote:
I want to take a list of numbers and sort them using functions in another
column

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this make sence.

Sorry Buddy,

But I did not have an answer elsewhere.

"Pete_UK" wrote:

Please don't multi-post - it fragments your answers and wastes
responders' time if you already have an answer elsewhere.

Pete

On Oct 12, 11:51 pm, zoomzoom632
wrote:
I want to take a list of numbers and sort them using functions in another
column

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this make sence.

Sorry, but I need to change this again,

Sheet one,
Column A: a bunch of numbers in a random order.

Sheet two,
Column B:

B1: =(min('Sheet One'A1:A50))
Rest of the C Column, I want it to be the next number to be the next number
in numerical order.
i.e. B2 = B1, but only then next largest number.

Hope this make sence.

Also, disregaurd "Informational Search" unless it could help you some how.

"zoomzoom632" wrote:

I want to take a list of numbers and sort them using functions in another
column

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this make sence.

Yes you did, under the thread "Informational Search", in which you
have now said to disregard this thread.

Pete

On Oct 13, 2:35 am, zoomzoom632
wrote:
Sorry Buddy,

But I did not have an answer elsewhere.



"Pete_UK" wrote:
Please don't multi-post - it fragments your answers and wastes
responders' time if you already have an answer elsewhere.

Pete

On Oct 12, 11:51 pm, zoomzoom632
wrote:
I want to take a list of numbers and sort them using functions in another
column

Sheet one,
Column A: a bunch of numbers in a random order.
Column B: nothing
Column C:

C1: =(min(A1:A50)
Rest of the C Column,
I want it to be the next number to be the next number in numerical order.
i.e. C2 = C1, but only then next largest number.

Hope this make sence.- Hide quoted text -

- Show quoted text -