Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting grouped rows
i have a very important list, some of the rows must be grouped (so you see
the plus sign on the left). when sorting the whole list - i'm loosing the groups. i would expect the excel to treat grouped rows like it was one row. instead it's spreading them according to the sub content. by the way - the plus remains in front of the original row number of the work sheet, even if the row content has changed place according to the sorting. so for instance if i grouped some rows to a single row, and it happend to be the row number 27, so after the sorting the plus remains infront of row 27 but the content has changed according to the sorting. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting grouped rows
thanks jim
i know there is an option to sort grouped rows, it works in one of the sheets i created! i have no idea why or what did i do differently in the other sheets i have probably done something in the only sheet that it's working there i think it's something to do with table definitions. "Jim Cone" wrote: You will probably have to use another column and add an unique identifier for each group. So your first group might have "AAAA" in each row and the next group would have "BBBB" in each row (in the new column) and so on. -- Jim Cone Portland, Oregon USA "david tlv" <david wrote in message i have a very important list, some of the rows must be grouped (so you see the plus sign on the left). when sorting the whole list - i'm loosing the groups. i would expect the excel to treat grouped rows like it was one row. instead it's spreading them according to the sub content. by the way - the plus remains in front of the original row number of the work sheet, even if the row content has changed place according to the sorting. so for instance if i grouped some rows to a single row, and it happend to be the row number 27, so after the sorting the plus remains infront of row 27 but the content has changed according to the sorting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouped columns & rows | Excel Worksheet Functions | |||
How to search for grouped rows? | Excel Worksheet Functions | |||
How to sort by grouped rows | Excel Discussion (Misc queries) | |||
Numbering of Grouped Rows | Excel Discussion (Misc queries) | |||
Grouped Columns/Rows | Excel Worksheet Functions |