Formula to sort numbers in ascending value into a new column

[bobmc]

Hi...

I have three columns of values that are in no particular order that need to be sorted in ascending order in another column.

Any ideas? Help would be greatly appreciated!

Thanks.

BobMc

 

[Aladin Akyurek]

Old thread, I know, but it's got great pagecount on Google so likely to be found often (helped me today).

Wanted to add to Andrew's solution with the following which saves having the helper row.
=SMALL($A$1:$A$10,ROW())

If you add a few rows before the formula row, you'd get unwanted results...

If you want the sorting in column B, modify it as follows:

=SMALL($A$1:$A$10,ROWS($B$1:B1))