Excel - filter on 2 columns - another one 1

[Andrzejek]

Advanced Filter works great, but how can I get the RED rows of data now based on:
Team Leader is either "Bill" or an empty cell in Column B:

[blue]STATUS   Team Leader    Team Member   Other info[/blue]
Active   Andy           Bob           Whatever
Avtive   Bob                          Some Info
[red]Deleted                 Andy          Blah blah blah[/red]
Active   Andy           Susie         ........
[red]On Hold  Bill           Janet         ........[/red]
Active
....

I can get "Bill" just fine, the empty cell is the problem.
I did try ="=""""" as criteria, and =B2="" (from some Internet sites)
but it does not work - I get "Bill" but all rows with empty cell in column B are not picked up.

Any ideas?

Have fun.

---- Andy

 

[AnotherHiggins]

Are you doing this in VBA?

Here's how to do in the spreadsheet. If you need a VBA solution, you can get the code through your Macro Recorder.

Click on the Auto Filter drop down arrow in column B and select (Custom...).
Equals[tab]Bill
OR
Equals

Leave the final box blank.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.