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