Hello, I want to be able to include '=blank' or '<blank' as a criteria for
one of my columns in my criteria range, but it doesn't seem to work.

Does anyone know a syntax for including all blanks (or all non-blanks) in my
criteria range?

Thanks

M

Hi,

In the criteria cell, use len(first_cell)=0 to include all blank cells. ust
ensure that the column heading in the criteria range for this column is not
equal one of the headings int eh source data

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Michelle" wrote in message
...
Hello, I want to be able to include '=blank' or '<blank' as a criteria
for one of my columns in my criteria range, but it doesn't seem to work.

Does anyone know a syntax for including all blanks (or all non-blanks) in
my criteria range?

Thanks

M