Include Data Only after a row containing a specific word

[lil_t]

Hi there,

I have a excel file that contains data formatted like this:

Name	Jan	Feb	March	April	May	June
Cat	1	2	3	4
Dog		3	4
Fish	1	3
Include	2	8	7	4
Cat	5	6	3
Dog		7	4
Exclude	5	14	14	4

How do I only include the rows starting and ending at Include?  (Bolded)

Thank you!

[BrandonB]

I like to use a formula tool to make a flag on the row where name contains the value, then use a running total on the flag column, and then a filter where you can say only include the rows where the running total is zero. Workflow is attached!

 

[BrandonB · Accepted solution]

I would use a multi row formula instead of a formula if you also need to include the row that says include. See workflow attached. 

[lil_t]

Thank you, that worked!