Remove Rows After a Certain text is detected in a field

[DataPirate26]

Hi Team, 

I want to Discard all the rows after the Keyword "Misc. income" is detected in Field F1. So only the blue part of the data is required after that the data needs to be discarded. Can someone help me write a single multi row formula which will help me to achieve this or any other approach 

[binuacs · Accepted solution]

@DataPirate26 One way of doing this with the Record ID tool

[Qiu · Accepted solution]

@DataPirate26 
If with multi-row formula, maybe we can do like this.

Check if one row up contains "Misc. income" or not then set a flag.

[DataPirate26]

@Qiu perfect . This works Fine. I was trying to get it through a Multi row formula only

[Qiu]

@DataPirate26 
Glad it helps.

[schuprov]

Hi, what if the location of the word is not static and changes depending on the day that data comes in? for example on day 1 I have 200 rows of data and word Total comes up on row 201 and next day I have 210 rows and total on row 211