Re-order numbers

[donman007]

Is there a way to take 5 cells that have random numbers in it and re-order them from lowest to highest automatically, A1, A2, A3, A4, A5 have random numbers, I want new results in A6, A7, A8, A9, A10. Example: 5,46,13,23,35 = 5,13,23,35,46

 

[indiantrix]

Put this formula into A6, and copy it down to A10.
=SMALL($A$1:$A$5,ROW()-5)
Larry.

 

[stnkynts]

A macro way:

Sub SortCopy()
Dim lastrow As Long
 
lastrow = Range("A" & Rows.Count).End(xlUp).Row
Application.ScreenUpdating = False

With Sheets("Sheet1").Sort
        .SetRange Range("A1:A5")
        'or this .SetRange Range("A1:A" & lastrow)
        .Header = xlNo
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
End With
Range("A1:A5").Cut Destination:=Range("A6")
'or this Range("A1:A" & lastrow).Cut Destination:=Range("A" & lastrow + 1)
 
Application.ScreenUpdating = True
End Sub

 

[donman007]

Oh man, i wrote that wrong, sorry, what i meant to say was

A1, B1, C1, D1, E1 have random numbers, I want new results in F1, G1, H1, I1, J1. Example: 5,46,13,23,35 = 5,13,23,35,46

 

[shg]

See indiantrix's post.

 

[T. Valko]

Oh man, i wrote that wrong, sorry, what i meant to say was

A1, B1, C1, D1, E1 have random numbers, I want new results in F1, G1, H1, I1, J1. Example: 5,46,13,23,35 = 5,13,23,35,46

Try this...

Entered in F1 and copied across to J1:

=SMALL($A1:$E1,COLUMNS($F1:F1))

 

[donman007]

Thank you works perfectly

 

[T. Valko]

Thank you works perfectly

You're welcome. Thanks for the feedback!