Good afternoon!
I have an excel spreadsheet I'm making that lists about 8-900 companies. There are 12-3 columns with certain types of info (contact name, phone, company type, etc)
They are organized by company type, so row 15 would say "Demolition Company" and then rows 16-40 will be the demo companies. Then 41 will say "Painting Company" and the following rows list all of my painting companies and so on.
In column K is a simple Yes or No. What I want to do is when I filter all of the Yes only lines and it pulls them in, it will ALSO pull in the "header" row they are under (for example, if there are 3 demo companies that have YES in column K, it will pull in row 15 that says "Demolition company" and then rows 17, 21, 23 or whatever ones meet the yes/no requirement I'm filtering)
Is there a way to do this? I can provide pics if that would help it make more sense.
I have an excel spreadsheet I'm making that lists about 8-900 companies. There are 12-3 columns with certain types of info (contact name, phone, company type, etc)
They are organized by company type, so row 15 would say "Demolition Company" and then rows 16-40 will be the demo companies. Then 41 will say "Painting Company" and the following rows list all of my painting companies and so on.
In column K is a simple Yes or No. What I want to do is when I filter all of the Yes only lines and it pulls them in, it will ALSO pull in the "header" row they are under (for example, if there are 3 demo companies that have YES in column K, it will pull in row 15 that says "Demolition company" and then rows 17, 21, 23 or whatever ones meet the yes/no requirement I'm filtering)
Is there a way to do this? I can provide pics if that would help it make more sense.