Advanced filter only show blanks

[RockandGrohl]

Me again, Advanced filter problems again.

I'm trying to do this filter:

Brochure_Region

OptIn_NH_LandMail

Last_Booked

Last_Booked

FamilyFun

FamilyFun

UK

UK

Sports

Sports

Events

Events

EU

EU

Showtime

Showtime

OptIn_ThirdParty

<>0

<>0

>=0

<=1000000

>=1

<=10000

"="

And I'm desperately trying to get "OptIn_ThirdParty" to show me blanks.

So the Sports column needs to have a value between 1 and 10,000, AND the OptIn_ThirdParty column needs to have a value of blank, which there are.

I should be getting 5,685 records, but instead I'm getting none.

It also doesn't work when I enter =, ="", "", <> or any other combination I can think of.

Thanks.

 

[RockandGrohl]

Apparently the only thing that works is =AH2=""

But that only works with a blank column heading. Surely there's a proper way of doing this. In the page where I learned this, How to Set Up Advanced Filter Criteria, it says

Option 2 - Filter for Blank Cells​

Use these criteria range settings to filter rows with blank cells

• F1: Criteria Heading -- Product (this is an exact match for the column heading)
• F2: Criteria: ="="

If I do this, zero records are returned, but by using =AH2="" it returns the correct amount of records.

 

[RockandGrohl]

Ah.

The cells in column AH aren't blank. They are the result of formulas where one condition is a string and the other result of a condition is "".

Is there an easy to take a range, say, AH2:AH & Lastrow, and convert all fake blanks to true blanks? Thanks.

 

[RockandGrohl]

I did this:

Range("AH2:AH" & Lastrow).select
With Selection
    Selection.NumberFormat = "General"
    .Value = .Value
End With

That was quick and easy, now ="=" works. Solved!