ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Grouping (https://www.excelbanter.com/excel-worksheet-functions/40678-grouping.html)

Vitruvius

Grouping
 
I need a spreadsheet "grouping" command to expand and collapse differently
than the normal process seems to allow.
For example: A list of: Year, Quarter, Month, Day (for multiple years). How
can I group this data to collapse to Years only, Year/Quarter only,
Year/Quarter/Month, and back to full detail. Like an outline?

bj

In what way doesn't the normal <data<group and outline meet your needs. It
sounds like it should.

"Vitruvius" wrote:

I need a spreadsheet "grouping" command to expand and collapse differently
than the normal process seems to allow.
For example: A list of: Year, Quarter, Month, Day (for multiple years). How
can I group this data to collapse to Years only, Year/Quarter only,
Year/Quarter/Month, and back to full detail. Like an outline?



All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com