Hi there, I have a excel file that contains data formatted like this: NameJanFebMarchApril MayJuneCat1234 Dog 34 Fish13 Include2874 Cat563 Dog 74 Exclude514144 How do I only include the rows starting and ending at Include? (Bolded) Thank you!

Include Data Only after a row containing a specific word

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!

Workflow

Accepted answers

BrandonB

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.

flag v2.yxmd

All comments

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!

flag.yxmd

BrandonB

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.

flag v2.yxmd

lil_t

Thank you, that worked!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335