Sort 2 ranges with same Key

[jlclyde]

Is it possible to sort 2 seperate ranges by one key? If I had range
A1:C10 and it coincided with G1:G10; Is there a way to sort by B1 to
sort all of the columns in the ranges accordingly?

Thanks,
Jay

 

[Sheeloo]

What about the data in D1:F10?

You can select A1:G10 and sort on B
then select D1:F10 and sort in the order you want... You might insert a
helper column and fill it with 1,2,3... to get the original order back.

 

[jlclyde]

What about the data in D1:F10?

You can select A1:G10 and sort on B
then select D1:F10 and sort in the order you want... You might insert a
helper column and fill it with 1,2,3... to get the original order back.






- Show quoted text -

B is the key column that I want to sort A:C and G. I want to leave
D:F alone. Is this possible?
Thanks,
Jay

 

[Sheeloo]

No, you can not sort on multiple ranges...

What I had suggested is a work around.