Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting multiple columns together
I have 2 columns in a sheet that are both labeled "Description", with a
number's column next to each of them. I want to sort both Description columns and have them alphabetized, but if there is information in the 2nd column, it needs to be put in order in the first. Can someone help me figure out how to do that? |
#2
|
|||
|
|||
"?B?c3dlZXRsZWRlZQ==?="
wrote in : I have 2 columns in a sheet that are both labeled "Description", with a number's column next to each of them. I want to sort both Description columns and have them alphabetized, but if there is information in the 2nd column, it needs to be put in order in the first. Can someone help me figure out how to do that? When you go through Data/Sort you can have multiple sort keys. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#3
|
|||
|
|||
If I understand correctly, select the pairs of columns, goto DataSort, and
select the first column as the sort column. -- HTH RP (remove nothere from the email address if mailing direct) "sweetledee" wrote in message ... I have 2 columns in a sheet that are both labeled "Description", with a number's column next to each of them. I want to sort both Description columns and have them alphabetized, but if there is information in the 2nd column, it needs to be put in order in the first. Can someone help me figure out how to do that? |
#4
|
|||
|
|||
I've already tried that, but it's not bringing over the information and
sorting it into the 1st column. "Bob Phillips" wrote: If I understand correctly, select the pairs of columns, goto DataSort, and select the first column as the sort column. -- HTH RP (remove nothere from the email address if mailing direct) "sweetledee" wrote in message ... I have 2 columns in a sheet that are both labeled "Description", with a number's column next to each of them. I want to sort both Description columns and have them alphabetized, but if there is information in the 2nd column, it needs to be put in order in the first. Can someone help me figure out how to do that? |
#5
|
|||
|
|||
And there are actually 4 rows that need to be sorted:
C5:DESCRIPTION D5:CHARGE CODE (with 2 columns in between) and then H5:DESCRIPTION I5:CHARGE CODE there is information into C5 (description column), with charge code numbers entered into D5, and then any new information that is entered into H5 and I5 needs to be sorted along with C5 and D5 and all info needs to be alphabetized. I hope that clears it up a little bit. Thanks! Sweetledee "Bob Phillips" wrote: If I understand correctly, select the pairs of columns, goto DataSort, and select the first column as the sort column. -- HTH RP (remove nothere from the email address if mailing direct) "sweetledee" wrote in message ... I have 2 columns in a sheet that are both labeled "Description", with a number's column next to each of them. I want to sort both Description columns and have them alphabetized, but if there is information in the 2nd column, it needs to be put in order in the first. Can someone help me figure out how to do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Multiple columns in a pivot table | Excel Discussion (Misc queries) | |||
spliting a column of data into multiple columns | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) |