| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort 2 ranges with same Key
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort 2 ranges with same Key
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" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort 2 ranges with same Key
On Nov 4, 1:01*pm, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) &
"hotmail.com" wrote: 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" wrote: 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- Hide quoted text - - 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort 2 ranges with same Key
No, you can not sort on multiple ranges...
What I had suggested is a work around. "jlclyde" wrote: On Nov 4, 1:01 pm, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: 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" wrote: 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- Hide quoted text - - 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by ranges? | Excel Discussion (Misc queries) | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Automatic Sort for variable Ranges | Excel Worksheet Functions | |||
| Limiting Sort Ranges | Excel Discussion (Misc queries) | |||
| Sort Macro: Utilizing ComboBox Selection for Key1 through 3 Ranges | Excel Discussion (Misc queries) | |||
Hybrid Mode
