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
Last edited by ali560045; 08-21-2008 at 02:27 AM.
And the queston is?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I think the OP is looking for a method to sort by matching Column 2 to the values in Column 1, maybe...
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
When I asked Ted, the post looked nothing like it does since he edited it.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Point taken Bob.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
does anyone know any macro script that will do this?
Do what? At this point all we have to work on, is that which I have surmised.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
