P
Pat
Why would the dropdown filter list leave out (Blanks) and (Nonblanks) from
the list?
the list?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
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
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
D
Debra Dalgleish
Those items are only included in the AutoFilter dropdown if the field
includes at least one blank record.
includes at least one blank record.
P
Pat
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
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
D
Dave Peterson
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.
=if(yourformula="","",yourformula)
a simple example:
=if(sheet2!a1="","",sheet2!a1)
It might make later processing less confusing.