Thread: Number Order
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zoomzoom632 zoomzoom632 is offline
external usenet poster
 
Posts: 19
Default Number Order

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.