Multi-Row Formula?

[insomned]

Hello, 

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

Hello
	x
	x
	x
Bye
	d
	d
Yes
	df
	d
No

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

Hello
	x
	x
	x

Thank you!

[ShankerV]

Hi @insomned 

This can be achieved with the help of Multirow formula and filter tool.

Many thanks

Shanker V

[insomned]

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

[ShankerV]

Hi @insomned 

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

Many thanks

Shanker V

[Raj]

one way of solving this