Apply Advanced Filter to Range

[pto160]

I have Excel 365.
I have a Bank statement and I have a formula to advance filter on one column. Is it possible to use this with a range?

Book1
	A	B	C	D
1	Original Formula
2	Comment	Comment 2
3	House	Fees
4	Tractor	Engine
5	Withdrawal	House
6
7			House	TRUE
8
9	What I like
10	Comment	Comment 2
11	House	Fees
12	Withdrawal	House
13
14			House	FALSE
Sheet1

Cell Formulas
Range	Formula
D7	D7	=ISNUMBER(LOOKUP(9.99E+307,SEARCH($C$7,A3)))
D14	D14	=ISNUMBER(LOOKUP(9.99E+307,SEARCH($C$14,A3:B5)))

The search function does not seem to work with ranges since I want to return row 3 and row 5 since house is in both of these rows.
Is this possible?

 

[pto160]

Absolutely perfect. This is exactly what I am looking for. Thank you so much. This will really help me with a bank report.

 

[Peter_SSs]

You're welcome.

However, while I was testing that I removed a check that we had in an earlier formula & forgot to reintroduce it before posting. That means that if cell D3 in the post 10 sample was "Hosehold A" that row would still appear in the results even though the row does not contain any of the actual "words" listed in column G. If you want to only search for those whole words ..

pto160.xlsm
	A	B	C	D	E	F	G
2	Account	Name	Type	Comment	Comment 2		Criteria
3	1000	Bank A	Checking	Household A	Fees		House
4	1000	Bank A	Checking	Tractor	Engine		Glass
5	1000	Bank A	Checking	Withdrawal	Computer		Bottle
6	1000	Bank A	Checking	Glass Z	Table
7	1000	Bank A	Checking	Door	Bottle C
8
9
10
11
12
13	What I like
14	Using an Excel Fomrula
15	Account	Name	Type	Comment	Comment 2
16	1000	Bank A	Checking	Glass Z	Table
17	1000	Bank A	Checking	Door	Bottle C
18
Sheet2

Cell Formulas
Range	Formula
A16:E17	A16	=FILTER(A3:E7,BYROW(D3:E7,LAMBDA(r,COUNT(MATCH("* "&G3:G5&" *"," "&r&" ",0)))),"")
Dynamic array formulas.

 

[pto160]

The formula works great. Thank you so much for this other option. I will end up using both options depending on the situation. so this is very useful.