| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping groups when filtering
I have a spreadsheet set up where each column has a header. (Status,
Priority, Responsibility, etc). Then amongst my data I have header rows, breaking them into groups (EE tasks, ME tasks, etc) I want to filter the rows where the Status cell contains "complete", but keep the groups together with the headers showing. Example is below. View before filtering Status Responsibility EE tasks complete Jim delayed Tom complete Dave ME tasks delayed Joe cancelled Sara complete Sally View after filtering Status Responsibility EE tasks complete Jim complete Dave ME tasks complete Sally What is the best way to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping data grouped when Filtering | Excel Discussion (Misc queries) | |||
| Filtering of Groups and Categories | Excel Discussion (Misc queries) | |||
| Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
| Filtering out single values (keeping only repeating data) | Excel Discussion (Misc queries) | |||
| Auto filter columns while keeping groups of verticle cells togethe | Excel Discussion (Misc queries) | |||
Hybrid Mode
