If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sort blocks of data
Can you assign groups of columns to move together when sorting horizontally?
I have 11 groups of columns each group with an amount column, ideally we have the list sorted from left to right descending dollar amounts for the amount column from each column group. Any ideas are much appreciated. -- "Gambling is illegal @ Bushwood and I never slice." |
#2
|
|||
|
|||
Sort blocks of data
If the data would fit into a single row (256 in xl2003 and below) or 16k in
xl2007, then I'd: Move the data to a separate worksheet -- one row per logical record Sort this data and then rearrange the data into the "report" version -- multiple rows per logical record. In fact, I'd do my best to keep my raw data (for updates) in that format and generate the reports off that flat file. ======= But another way that may work for you. Insert a couple more columns (I'd use new columns A and B) Add a unique record indicator in column A of each group of rows. Add a sequence number in column B within that group of rows. Sort your data using the way you want and then sort it once more using the first two columns. bushwood wrote: Can you assign groups of columns to move together when sorting horizontally? I have 11 groups of columns each group with an amount column, ideally we have the list sorted from left to right descending dollar amounts for the amount column from each column group. Any ideas are much appreciated. -- "Gambling is illegal @ Bushwood and I never slice." -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|