Remove row if condition met question

[rockeylearning]

Hi Community and Happy new Year!

I'm looking at the Multi-Row Formula, but I can't wrap my head around on how to do this.

I have data like this below

ID	Identifier	Amount
15687	Line	10
15687	Line Split	5
15687	Line Split	5
15688	Line	20
15699	Line	24
15699	Line Split	12
15699	Line Split	12
15700	Line	56

It is group by the ID, the desire is to delete the first row "Line"' if the second row and after is Line Split in the Identifier.

How can I achieve this with Multi-Row Formula? or is there a different tool better use?

Thank you!

[trzeciakwojtek · Accepted solution]

Will this work for you?

 

 

[rockeylearning]

@trzeciakwojtek this works! Thank you so much!