Finding Blank or empty Cells using Advanced Filter

[jhuck]

Can anyone tell me how to find Blank or Emmpty cells using the advanced filter. I have tried "", "Blank", (Blank), etc. nothing seemd to work

Thanks for your help
John

 

[xlbo]

why are you using advanced filter for this ???

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[jhuck]

I am trying to find all of the rows that have a specific entry in column B, any entry in column C and A is blank in a spreadsheet that is about 63,00 lines long. Unfortunately I can not sort to get the blanks out because of a formula issue.

John

 

[xlbo]

have you tried using plain old autofilter ??

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[jhuck]

Yes but when found it says that the feild is too Complex so I can't copy or cut the info.

By the way, Thanks for helping me!

 

[Zathras]

The help file gives some examples of advanced filter criteria which points the way to something like this for the criteria range (in E1:G2): (You didn't provide us with the column headers so I am using AAA, BBB and CCC. You need to replace with the actual column headers you are using:
[blue]

E1: 
F1: 'BBB
G1:
E2: =A2=""
F2: 'ACCT
G2: =C2<>&quot;&quot;

[/color]
Note that E1 and G1 are blank.

 

[jhuck]

Zathras,

Thanks, I will try this as soon as I get a chance.

John