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