| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping data grouped when Filtering
I have a spreadsheet where each column has a header cell ("Status, Priority,
Responsiblity, etc). Then I have the data broken up in groups, with one row acting as the group header. (Software, Electrical Mechanical, etc) I want to filter the data to only show items where the Status cell contains 'Complete'. But I want my groups to stay in tact, leaving the row headers in place. What is the best solution? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping data grouped when Filtering
Put that grouping value on every row that should be displayed.
JCT77 wrote: I have a spreadsheet where each column has a header cell ("Status, Priority, Responsiblity, etc). Then I have the data broken up in groups, with one row acting as the group header. (Software, Electrical Mechanical, etc) I want to filter the data to only show items where the Status cell contains 'Complete'. But I want my groups to stay in tact, leaving the row headers in place. What is the best solution? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping data grouped when Filtering
I would like to avoid that if possible. I have so many rows it makes the
spreadsheet look really busy. PS. Sorry about the multiple posts. It gave me two errors saying my post was not submitted. But apparently they did) "Dave Peterson" wrote: Put that grouping value on every row that should be displayed. JCT77 wrote: I have a spreadsheet where each column has a header cell ("Status, Priority, Responsiblity, etc). Then I have the data broken up in groups, with one row acting as the group header. (Software, Electrical Mechanical, etc) I want to filter the data to only show items where the Status cell contains 'Complete'. But I want my groups to stay in tact, leaving the row headers in place. What is the best solution? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median calculation of grouped data. | Excel Worksheet Functions | |||
| Group data and maintain grouped data on dedicated pages | Excel Worksheet Functions | |||
| How to retrieve grouped items data | Excel Discussion (Misc queries) | |||
| Filtering grouped worksheets | Excel Discussion (Misc queries) | |||
| Filtering out single values (keeping only repeating data) | Excel Discussion (Misc queries) | |||
Hybrid Mode
