keeping groups when filtering

[JCT77]

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?

 

[Bob Umlas, Excel MVP]

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"

 

[Alojz]

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.