Multi-Row Formula?

Question

Hello,

I would need the multi-row formula, which would extract everything between two cells, so my data is:

Hello  x     x       xBye  d     dYes    df   dNo

I want the formula to extract everything between say "Hello" and "Bye" and bring me just:

Hello  x     x       x

Thank you!

Raj · Answer

one way of solving this

ShankerV · Answer

Hi @insomned

IF [Field1]= "Hello"
THEN 1
ELSEIF [Field1]= "Bye"
THEN 0
ELSE [Row-1:Temp]
ENDIF

Many thanks

Shanker V

Multi-Row Formula.yxmd

insomned · Answer

Could you please elaborate what exactly should I input in the formula? Thanks!