Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello again,
I have an "outline" issue: Actually Rows should be GROUPED. No totals to be made ..just grouping some rows together. Situation: -The grouping should be based on with condition in column B: ie: Is the font of this cell BOLD? -Evaluation of this condition always starts on row 7. So, I might have 1000 rows. If cell B19 = Bold then Group row 7 till 18 If next bold cell = B35 then Group row 20 till 34 etc etc ( If there are 2 adjacent B-cells in BOLD, then basically a 2nd level grouping should happen. In the example: If B36 = Bold then 2nd level Grouping should happen: Grouping Row7-Row35 ) No idea on how to knit this together, Looking forward to your ideas! Sige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hierarchical outlining | Excel Worksheet Functions | |||
Subtotal and outlining | Excel Discussion (Misc queries) | |||
How Outlining w/o numbers possible? | New Users to Excel | |||
outlining / Grouping | Excel Discussion (Misc queries) | |||
Outlining Limit | Excel Programming |