Numerical order

**leighmills33** · 03-15-2010, 08:29 AM

Is there a formula to order a list of cells into numerical order. I have a list of numbers in a different order but I want them numerical order. Can this be done.

Thanks

**sweep** · 03-15-2010, 08:33 AM

Hi,

=LARGE(array,n)

returns the nth largest value in array.

=SMALL(array,n)

does the opposite.

**leighmills33** · 03-15-2010, 09:01 AM

ok so to use this formula if I had 2,6,8,10,1,3,9,7 column A and wanted it in numerical order in column b how would I write that formula. Thanks

**sweep** · 03-15-2010, 09:06 AM

Presuming your data starts at A1,

=SMALL($A$1:$A$8,ROW()) in B1, and then copied down will numerically order the data.

NB - if the range of data doesn't start at B1, you will need to modify the ROW() portion of the formula. Eg, if the data starts at A4,

=SMALL($A$4:$A$11,ROW()-3) copied down.