Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting
Sorting issue
I have a column "c1" that is a name list and am trying to get "C2" to sort alphabeticaly by "c1." I also need "c3" and "c4" to follow the same as "c2". Any suggestions would help greatly. Thank you Jeremy C1 C2 C3 C4 Capital Body Shop Capital Body Shop 37.05 37.05 Cars For Less Cash Sale Cash Sale 3,143.66 0 Central Auto Chico's Cleburne RV Cleburne RV 1,982.77 121.89 |
#2
|
|||
|
|||
Hi Jeremy,
Put your cursor in cell that contains "c1." Go to Data Sort... You should get a dialog box that opens and the range of cells you want to sort should be highlighted with the exception of the header row. You can then select the columns you want to sort. After you clilck OK, all the highlighted cells will sort. -- Ken Hudson "Jeremy" wrote: Sorting issue I have a column "c1" that is a name list and am trying to get "C2" to sort alphabeticaly by "c1." I also need "c3" and "c4" to follow the same as "c2". Any suggestions would help greatly. Thank you Jeremy C1 C2 C3 C4 Capital Body Shop Capital Body Shop 37.05 37.05 Cars For Less Cash Sale Cash Sale 3,143.66 0 Central Auto Chico's Cleburne RV Cleburne RV 1,982.77 121.89 |
#3
|
|||
|
|||
Hey Ken
You are right but the problem I will have is it won't line up the text in c1 with the name in c2, instead it will bunch them together in the columns and I want there to be blanks if the name is in c1 but not c2. "Ken Hudson" wrote: Hi Jeremy, Put your cursor in cell that contains "c1." Go to Data Sort... You should get a dialog box that opens and the range of cells you want to sort should be highlighted with the exception of the header row. You can then select the columns you want to sort. After you clilck OK, all the highlighted cells will sort. -- Ken Hudson "Jeremy" wrote: Sorting issue I have a column "c1" that is a name list and am trying to get "C2" to sort alphabeticaly by "c1." I also need "c3" and "c4" to follow the same as "c2". Any suggestions would help greatly. Thank you Jeremy C1 C2 C3 C4 Capital Body Shop Capital Body Shop 37.05 37.05 Cars For Less Cash Sale Cash Sale 3,143.66 0 Central Auto Chico's Cleburne RV Cleburne RV 1,982.77 121.89 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |