Filter for blanks - nonblanks problem

  • Thread starter Thread starter Paul
  • Start date Start date
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.
 
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

Similar Threads

Limit filter options in Auto Filter 1
Filter not showing blanks option 6
Looking uprange for next nonblank cell 4
sort a table that contains both numbers and blank cells 1
How do I create a list of each distinct entry in a group of column 3
How to count interstitial blank cells? 3
Horizontal Filtering 5
Dropdown list and filtered data 8

Back
Top