Advanced Filter Excel 2007 1

[Kelser]

What I want to do:
IF the row in Column AG and AH are both blank then don’t show that row, but if only one of the columns contain a blank or both contain data then show that row.

I tried this with an advanced Filter, doing an AND but it doesn't work. If I filter using <> under 1 column heading, it does work for that column, but if I put up 2 headings and use that criteria under the 2nd heading as well, it doesn't work as an AND, but as 2 individual filters.

Thanks for any help

 

[SkipVought]

Hi,

Would the AutoFilter not work?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Kelser]

Unfortunately not, the AutoFilter only looks at each individual column so it removes all blank rows, regardless of whether the other column has blanks in the same row or not. That's why I tried to do it with the Advanced Filter so that I could make it look at 2 columns at the same time. Does that make sense?

 

[SkipVought]

Absolutely NOT!

You DESELECT BLANKS in BOTH column filters!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

OOPS, misread your criteria.

I'd add a helper column
[tt]
=AND(AG2="",AH2="")
[/tt]
and filter that column on TRUE

Sorry!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Rather filter on FALSE to NOT display rows where BOTH are blank.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Kelser]

Works perfectly! Thank you so much for your help.