Sorting two columns

[scgwebmaster]

How to sort two columns A and B but not first by A then by B? I want to
sort these two columns in the same time like one columns.

For example
column A (a, b, d )
column B (a, c, d )

after sorting

column A (a, a, b)
column B (c, d, d)

Thanks

 

[Guest]

Hi:

You can do the sort in several steps:

Say you have data in A1 thru A100 and B1 thru B100
Say column C is un-used

1. Copy A1 thru A100 to C1 thru C100
2. Copy B1 thru B100 to C101 thru C200
3. Sort Column C
4. Copy C1 thru C100 back to A1:A100
5. Copy C101 thru C200 back to B1 thru B100