Filter for blanks - nonblanks problem

P

Paul

I have columns in a worksheet, columns A thru J.
Columns F and J are date fields.
I need to filter both for non blanks.
When I apply the filter to one, I lose the ability to filter for
nonblanks from the other. The choice, Nonblanks, disappears.
Can anyone explain this behavior.

Thank you.
 
M

mrice

It might help if you select the entire area containing your data before
applying the autofilters. I've been able to select for non-blanks in
multiple columns when I've done this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top