| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keeping groups when filtering
For the filter of Status, you can do a Custom Filter, choosing Equals Complete
then select the Or button, and Ends With, and then "tasks" "JCT77" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keeping groups when filtering
Bob's suggestion works. For more complex filtering use advanced filter.
Above ur list insert several emty rows. Create here the area for filter criteria. In first row type Status, bellow this cell place the list of ur tasks vertically: EE tasks, ME tasks, etc. To the next cell bellow type the status you want to see, in this case: complete. leave at least one row empty between criteria area and original list area. Go to data-filter-advanced filter, assign criteria area, list area. That's it! Click yes if this is helpful. "JCT77" wrote: 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) | |||
| Keeping groups when filtering | Excel Discussion (Misc queries) | |||
| Filtering of Groups and Categories | Excel Discussion (Misc queries) | |||
| 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) | |||
Linear Mode
