excel 2007 filter help

[RetrogradePAK]

i have the following table and what i need to do is not to show or filter out the rows where both the value 1 and value 2 are blanks:

name value 1 value 2
a 1
b 3
c
d 2
e 5
f


As you can see rows with name c and f should be filtered out

 

[Gavona]

check out advanced filter with criteria <>""

http://www.contextures.com/xladvfilter01.html

Gavin

 

[MattGreer]

Gavona, that didn't work for me. I tried entering:

="=<>"""

The result in the cell was:

=<>"

And it didn't work. Likewise, I tried:

="=<>""""

The result in the cell was:

=<>""

Still didn't work. I'm not sure what I need to enter to only show cells with something in them.

Thanks.

Thanks!!


Matt

 

[Gavona]

Help with advanced filter:

http://www.contextures.com/xladvfilter01.html

Are your cells really blank?

A different approach:
Create a helper column to identify the rows you want to hide then use Autofilter on that column.
Populate the helper column by using autofilter criteria in both columns to SHOW the data you want to hide. Enter "Hideme" in all the visible cells in the helper column (select them all, type "Hideme" then hold Ctrl as you press enter)
Data,Filter,Showall (sorry - that is 2003 not 2007)
Then custom filter on your helper column to NOT Equal "Hideme"



Gavin

 

[Gavona]

Forgot to add:

="="""""


Gavin

 

[MattGreer]

The cells are not empty, technically speaking. They contain a formula. If the forumla is true, a number appears in the cell.

I added the "helper" column. Not the desired solution but it will do what I need.

Thanks!!


Matt