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.