J
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?
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?