Help in sorting

[svkshailendra]

I have a table with random values like this :


4 45 232 808 909 4444
39 66 444 343 455 4545

and i must have the end result like this

4 39 45 66 232 343
444 455 808 909 4444 4545

please guide how to sort like that in excel .

[Azam Ali]

The above data is in a column or in a row?

if the above values are in column then these could be sort thourgh simple sort command

If your problem is not solved, upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button

[svkshailendra]

See there are 2 rows and 6 columns

1st row has values : 4,232,808,4444,909,45

2nd row has values : 39,4545,444,343,455,66

now when i sort using the simple sort function it is displaying

Frst row : 4,45,232,808,909 ,4444

second row : 39,66,444,343,455,4545

i.e,. it is just sorting the row..but the 39 present in the second row should come to the frst row after 4 for my requirement like

Frst row : 4,39,45,66,232,343

Second row :444,455,808,909,4444,4545

i dnt need excel to differentiate the rows and columns...it should combine accordingly i.e., values from second row should be shifted to frst row if needed like 39 which is present in the second row should come to frst row bcos it is the next greater digit after 4.... I think there must be some simple way which i am unable to find

[Azam Ali]

The follwing workaround could be helpful

In A4 use =SMALL($A$1:$F$2,COLUMNS($A$1:A1))
In A5 use =SMALL($A$1:$F$2,COLUMNS($A$1:A1)+6)

another option for A5 =SMALL($A$1:$F$2,COLUMNS($A$1:A1)+MATCH(9.99999999999999E+307,1:1))


and copy to the right cells

[svkshailendra]

thank you azam for ur help..but it is difficult for some people to come up with formulas like this...i mean is there anyway where we can input a table of multiple rows and columns and get the output in ascending order of values without giving formulas and getting the output just by a couple of mouse-clicks...anywhere not only in excel..