How do I formulas to convert values into numeric order?

  • Thread starter Thread starter dkenebre
  • Start date Start date
D

dkenebre

How do I convert the 3 cells below in the correct order columns
to the 3 cells in Numeric order columns, using excel formulas.
or how to convert the 3 individual cells into one cell in numeric
order?

Correct Value,,,,,,,,,,,,,Numeric Order
9,,,,,,2,,,,,,6,,,,,,,,,,,,,,,,2,,,,,,,6,,,,,,,,9

Correct Value,,,,,,,,,,,,,,,,,,,Numeric Order
9,,,,,,2,,,,,,6,,,,,,,,,,,,,,,,,,,,,,,,,,,,,2,6,9

Thank you
 
Select the 3 cells you wish your numeric order to appear in, and type in the following formula:-

=SMALL(A1:C1,{1,2,3})

Then array enter it using CTRL+SHIFT+ENTER at the same time.

Select those 3 cells and then just copy down if it is a list.
 
Good stuff. If you had more columns than that and didn't want to type out all the aruments inside
the array constant bit ( {1,2,3,....} ), then you could use the following formula, which generates
the same thing, but using COUNTA to get the upper limit:-

=SMALL(A1:AJ1,COLUMN(INDIRECT("1:"&COUNTA(A1:AJ1))))
 
Back
Top