Another play to try out ..

Assuming the inputs are in B1 across

In B2:
=IF(B1="","",B1+COLUMNS($A:A)/10^10)
Leave A2 blank

In B3:
=IF(COLUMNS($A:A)COUNT(2:2),"",INDEX(1:1,MATCH(SM ALL(2:2,COLUMNS($A:A)),2:2,0)))
Select B2:B3, copy across to cover the max expected extent of inputs (in B1
across). B3 across will return the required ascending sort of inputs, all
neatly bunched to the left. Duplicate input numbers, if any, are also catered
for.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"scidoc" wrote:
I have a row of 6 random ordered numbers. I with to find out how to
automatically copy them into another row and have them in Ascending numerical
order. I'm at a loss to figure out what function can do this.

Example:
Input 9 4 56 8 2 27

Output 2 4 8 9 27 56

Thanks, Scidoc