sort numbers in columns

[cds]

Hi, I am using excel 2003, I want to know how sort data in various columns in ascending or descending order. My data is like this :

a b c d e f
1 12 4 11 27 35 20
2 9 17 4 23 29 35
3 3 8 23 17 29 26

After sorting I want result like this :-


1 4 11 12 20 27 35
2 4 9 17 23 29 35
3 3 8 17 23 26 29

Thanks in advance


cds

 

[Andrew Poulsom]

In the Sort dialog click Options and check 'Sort left to right'. To get the result you want you will need to sort one row at a time.

 

[Jonmo1]

You can use a formula in say H1 (or wherever you want) and filled right/down as needed
=SMALL($A1:$F1,COLUMNS($A1:A1))

Once you have the result, you can copy the formula cells, and paste special / values over the top of the original.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	12	4	11	27	35	20		4	11	12	20	27	35
2	9	17	4	23	29	35		4	9	17	23	29	35
3	3	8	23	17	29	26		3	8	17	23	26	29
Sheet1