filter 2 columns to show only if either one has data

[bucci35]

Hi,
I have these 3 columns and I want to be able to filter them so I end up with the table below. Any help would be appreciated!
Thanks Dan

B	C	D
Mortgage	$975.00	$960.00
YMCA	$ 10.00
Student Loans
First Energy (Electric)		$ 40.00
Illuminating (Gas)	$135.00	$200.00
data
data

This is what I want to end with filtered

Mortgage	$975.00	$960.00
YMCA	$ 10.00
First Energy (Electric)		$ 40.00
Illuminating (Gas)	$135.00	$200.00

 

[Skybluekid]

Hi, try this

Book1
	A	B	C	D	E	F	G	H
1
2	Mortgage	$975.00	$960.00		Mortgage	$975.00	$960.00
3	YMCA	$ 10.00			YMCA	$ 10.00	0
4	Student Loans				First Energy (Electric)	0	$ 40.00
5	First Energy (Electric)		$ 40.00		Illuminating (Gas)	$135.00	$200.00
6	Illuminating (Gas)	$135.00	$200.00
7	data
8	data
9
Sheet3

Cell Formulas
Range	Formula
E2:G5	E2	=FILTER(A2:C8,(B2:B8<>"")+(C2:C8<>""))
Dynamic array formulas.