Using Advanced Filter to find blank cells

To use an advanced filter on blank cells, you need to specify the criteria for each column where you want to identify a blank cell as:=

="="""""
(That's right, five double quotes in a row)

This is the same as in VBA, where if you want to include the string " within code, you need to duplicate it.

So (assuming I have understood you correctly, you could have (assuming row 1 contains column labels consitent with the data):
A2 - ="="""""
B2 - <>"="""""
etc to filter non-blanks and blanks as required. Using different rows to specify your "or" choices, this would appear to work properly.

Hope this helps!

Matt

I'll assume that the first record of your list is in row 5, with labels on row 4.

Define a range named Criteria at a1:a2.
Leave cell A1 blank. Put the following in A2:
=or(isblank(a5),isblank(b5),isblank(c5))

Then, use the Advanced Filter on your range
(it will assume automagically that you want to
use a1:a2 as the criteria range).

HTH

Perhaps I should explain myself a little more. I was just using A,B,C as examples what I actually need is to know how to do that on multiple rows. I have about 30 rows that I need to search across, and 5,000 records to search through.

What I will end up doing is to use logic to show the records where A is blank, C is not blank, and D is not blank or where is blank, E is not blank, and D is not blank. . .

Thanks in for your help so far!