Select Row after a Row with a Specific Word

[insomned]

Hello everyone, 

I want to select THE NEXT row after a row, which contains a specific word. Let's say I have

Column Name

Data

Data and Data

Phone Number

XXX-XXX-XXX

Data

Data

More Data

Now I want to select XXX-XXX-XXX, always the row, which goes after the "Phone Number" row. How I can do this?

Thanks!

[alexnajm]

The Multi-Row Formula tool should help you mark those rows! Something like:

IF Contains([Row-1:Column Name],"Phone Number") THEN 1 ELSE 0 ENDIF

[caltang]

Alternatively, you can try:

[Qiu]

@insomned 
Follow the idea of @alexnajm , a quick sample for your reference.

[caltang]

@insomned if the above helped you, kindly mark them as accepted solutions to close the thread accordingly.

By doing so, it also helps other users with similar problems to find the solution better.

Thanks!