Where specific word find how to pick data from row one till that word find

[NiranjanK1]

Hello All,

I just want to pick the data details till where second Ex-date end.  Where second Ex-date find/end i just want to pick data from row 1 to second Ex-d

[ShankerV]

Hi @NiranjanK1 

Use the Multi Row formula tool,

Create the value as 1 and 2 when Ex-date is found.

Then read rows until 2.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @NiranjanK1 

Please find the solution below.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[NiranjanK1]

@ShankerV Thank you Shankar, that was really usfull solution 

[ShankerV]

@NiranjanK1 

Welcome, happy to support anytime.

Advance new year wishes!!!!