Filter where multiple columns are blank

[LGFN1]

This is probably a simple filter, but I couldn't figure this out. I have two columns, I'd like the filter to show only the rows where BOTH columns are not blank. How can I apply such?

 

[Andrew Poulsom]

Here you are:

Excel 2010
	A	B	C	D
1	Col1	Col2
2	a	a		TRUE
3		a
4
5	d	a
6	e
7		a
8	g	a
9	h	a
10	i	a
Sheet1

Cell Formulas
Range	Formula
D2	=OR(LEN(A2),LEN(B2))

 

[LGFN1]

I feel so ignorant here I have no idea how I now apply it to the advanced filter it should hide, in your case, row 4.

I appreciate your constant patience, Andrew!

 

[Andrew Poulsom]

Select A1:B10 and click Advanced in the Sort & Filter group on the Ribbon's data tab. Make sure that the List range is A1:B10, select D1:D2 for the Criteria range and click OK.