subgroups

[Friedrich Vosberg]

Morning.

Is it possible to create subgroups subordinated to grouped columns or
rows?

+-----------------------,
+-----------, %% This subgroup i'ld need.
| | | | |
-----|-----|-----|-----|-----|-----
| | | | |
-----|-----|-----|-----|-----|-----

TIA and kind regards, Friedrich

 

[Jim Gordon MVP]

Hi Friedrich,

Perhaps a Pivot Table is what you are seeking. Visit this URL and see if
this is what you are looking for.
http://www.contextures.on.ca/xlfaqPivot.html

-Jim Gordon
Mac MVP

Morning.

Is it possible to create subgroups subordinated to grouped columns or
rows?

+-----------------------,
+-----------, %% This subgroup i'ld need.
| | | | |
-----|-----|-----|-----|-----|-----
| | | | |
-----|-----|-----|-----|-----|-----

TIA and kind regards, Friedrich

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[JE McGimpsey]

Morning.

Is it possible to create subgroups subordinated to grouped columns or
rows?

+-----------------------,
+-----------, %% This subgroup i'ld need.
| | | | |
-----|-----|-----|-----|-----|-----
| | | | |
-----|-----|-----|-----|-----|-----

I'm not sure what you mean by "subordinated to", but you can certainly
group columns under other groups. Just make sure the "outer" group is
expanded when you group the "inner" columns/rows.