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

 

[k209310]

Cant you just use sort?

 

[Andrew Poulsom]

Like this?

BOOK5
	A	B	C	D	E
1	35	1	15
2	75	2	25
3	65	3	35
4	45	4	45
5	55	5	55
6	15	6	65
7	25	7	65
8	95	8	75
9	85	9	85
10	65	10	95
11
Sheet1

 

[vanilladan]

Or you could use the LARGE formula.
Say, in column D (presuming no column had no more than 10 rows of data):

=LARGE($A$1:$C$10,1)

=LARGE($A$1:$C$10,2)

and so on...

Vanilladan

 

[bobmc]

THANK YOU!

(Actually, I substituted the word "SMALL" FOR "LARGE" and it gave me the desired ascending order.)

THANK YOU!

BobMc

 

[Andrew Poulsom]

On 2003-02-14 06:11, bobmc wrote:
THANK YOU!

(Actually, I substituted the word "SMALL" FOR "LARGE" and it gave me the desired ascending order.)

THANK YOU!

BobMc

I think that gives descending order.

 

[bobmc]

Well, I tried the LARGE function first and it retrieved the largest number from the selected range. I wanted ascending order, which (unless I'm mistaken) is smallest to largest, so I used the command SMALL instead and it resulted in the smallest number retrieved first.

At any rate, it worked! I'm thrilled!

BobMc

 

[raj08536]

Can I sort following (non numbers) also?
Cal A
Peter
Sam
Raj
David

 

[VLG]

Thank you. First search result and this worked like a champ.

 

[duffry]

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())