Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Problems
I have a worksheet that has the following information.
rows with several columns. These columns have information that only applies to what is in that row. Company Balance Acct # a 1 a1 b 2 a2 c 3 a3 d 4 a4 e 5 a5 Ther are more columns with more information. If I sort by balance, then the rest of the columns do not go with the company name. THe balance is sorted, but everything else stays put. I need each row to stay together when it is either sorted by alpha, numeric, whatever. thanks for your help Ron |
#2
|
|||
|
|||
Select *all* columns with data prior to sorting.
HTH Jason Atlanta, GA -----Original Message----- I have a worksheet that has the following information. rows with several columns. These columns have information that only applies to what is in that row. Company Balance Acct # a 1 a1 b 2 a2 c 3 a3 d 4 a4 e 5 a5 Ther are more columns with more information. If I sort by balance, then the rest of the columns do not go with the company name. THe balance is sorted, but everything else stays put. I need each row to stay together when it is either sorted by alpha, numeric, whatever. thanks for your help Ron . |
#3
|
|||
|
|||
Ohh, how simple it was.
Thanks Jason "Jason Morin" wrote: Select *all* columns with data prior to sorting. HTH Jason Atlanta, GA -----Original Message----- I have a worksheet that has the following information. rows with several columns. These columns have information that only applies to what is in that row. Company Balance Acct # a 1 a1 b 2 a2 c 3 a3 d 4 a4 e 5 a5 Ther are more columns with more information. If I sort by balance, then the rest of the columns do not go with the company name. THe balance is sorted, but everything else stays put. I need each row to stay together when it is either sorted by alpha, numeric, whatever. thanks for your help Ron . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) | |||
Sorting Problems | Excel Discussion (Misc queries) |