Number Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Please don't multi-post - it fragments your answers and wastes
responders' time if you already have an answer elsewhere.

Pete
 
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.
 
Yes you did, under the thread "Informational Search", in which you
have now said to disregard this thread.

Pete
 
Back
Top