Hi All,

This is a sort-of bizarre query I have.

I have a large array of data which I'm filtering out and copying to a new spreadsheet using an advanced filter. I have 2 filter criteria, one works... the other doesn't.

The second criteria is supposed to filter out rows that have blank cells in column C or D. I tried various things:

a. at first I tried following:
Column header: Name |Surname
Criteria: <>"" |<>""

b. since it didn't work I tried that
Column header: Name |Surname
Criteria: =<>""""" |=<>"""""

I also tried <>0 and <>null with absolutely no joy.

c. once I figured out that doesn't work either, I tried:
Column header: (empty)
Criteria: =OR(NOT(ISBLANK(C2)),NOT(ISBLANK(D2)))

now, the last one did have some effect, most of the empty-celled rows have been filtered out. However the filter persistently picks up ONE row that has blanks in column C2 and D2. I checked the data to check if the cell is really blank and it's as blank as it gets.

Obviously, I need help. It's been 3 days and I still can't figure out what's wrong with my filter. Is there a way of fool proofing the criteria, so that it will filter out all cells that are or appear to blank?

Thanks
Seler
(PS. no, I don't have single quotes in those cells. Nor spaces. they are really very blank.)