Remove Rows After a Certain text is detected in a field

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

test Data.xlsx

Dynamic Processing

Accepted answers

binu_acs

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

Remove_Rows_05_07.yxmd

Qiu

@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.

0705-DataPirate26.yxmd

All comments

binu_acs

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

Remove_Rows_05_07.yxmd

Qiu

@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.

0705-DataPirate26.yxmd

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317