Filter drop down list not complete

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Why would the dropdown filter list leave out (Blanks) and (Nonblanks) from
the list?
 
Hi
have you checked tha range of your drop down list. Another reason for
ommitting blanks could be that you checked this option in the data
validation dialog
 
Those items are only included in the AutoFilter dropdown if the field
includes at least one blank record.
 
Hello Frank

I have discovered the source of the problem, the formula contained in the
column displays (0) zero when there is nothing to return for the formulas. I
got round this by custom formatting the column General;General; to remove
unwanted zeros. Now the filter list is complete.

Cheers
Pat
 
One way to actually return an empty string is to modify your formula:

=if(yourformula="","",yourformula)

a simple example:
=if(sheet2!a1="","",sheet2!a1)

It might make later processing less confusing.
 
You must log in or register to reply here.

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

Filtered drop down list 2
Filter not showing blanks option 6
Limit filter options in Auto Filter 1
How do I create a list of each distinct entry in a group of column 3
Horizontal Filtering 5
Filter for blanks - nonblanks problem 1
How to delete a drop down box in Excel 2007 1
Dropdown list and filtered data 8

Back
Top