Number Order

[Guest]

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.

 

[RagDyer]

Enter this in C1, and copy down as needed:

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

 

[Pete_UK]

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

Pete

 

[Guest]

Sorry Buddy,

But I did not have an answer elsewhere.

 

[Guest]

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.

 

[Pete_UK]

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

Pete