PDA

View Full Version : need help in excel sort



ali560045
08-21-2008, 02:16 AM
i have a excel file having 2 columns in it.below the details

ColumnA ColumnB
--------- ----------

1 34
2 3
3 11
5 55
9 5
11 34
34 9
55 2

----------------------------------------------------------------

i want to sort the column B according to column A i.e. my o/p should look like below


ColumnA ColumnB
--------- ----------
1 1
2 2
3 3
5 5
9 9
11 11
34 34
55 55

Bob Phillips
08-21-2008, 02:20 AM
And the queston is?

Aussiebear
08-21-2008, 02:52 AM
I think the OP is looking for a method to sort by matching Column 2 to the values in Column 1, maybe...

Bob Phillips
08-21-2008, 04:30 AM
When I asked Ted, the post looked nothing like it does since he edited it.

Aussiebear
08-21-2008, 02:59 PM
Point taken Bob.

ali560045
08-22-2008, 03:04 AM
does anyone know any macro script that will do this?

Aussiebear
08-22-2008, 04:27 AM
Do what? At this point all we have to work on, is that which I have surmised.