software

I am working with a worksheet that has the autofilter applied. The list does
not reflect (Blanks) and (no blanks) and there are blank cells. How do I get
this added to my list -gt;gt;gt;gt;gt;Help ASAP Thanks

Maybe the empty cells actually have a space or something in them, or maybe
the (Blanks) and (No blanks) options are at the other end of the drop down
list.

Vaya con Dios,
Chuck, CABGx3
quot;red1quot; wrote:

gt; I am working with a worksheet that has the autofilter applied. The list does
gt; not reflect (Blanks) and (no blanks) and there are blank cells. How do I get
gt; this added to my list -gt;gt;gt;gt;gt;Help ASAP Thanks

My first suggestion would be to turn off the AutoFilter and reapply. See if
that clears it up.

Next suggestion, do you have more than 1000 different entries being
filtered? The AutoFilter will only display up to 1000 unique values. All
data will still be filtered, but only the first 1000 values will show up on
the list. In this case, you can Filter for a Custom value. Select quot;Equal
toquot; or quot;Does Not Equalquot; and leave the criteria blank.

HTH,
Elkar

quot;red1quot; wrote:

gt; I am working with a worksheet that has the autofilter applied. The list does
gt; not reflect (Blanks) and (no blanks) and there are blank cells. How do I get
gt; this added to my list -gt;gt;gt;gt;gt;Help ASAP Thanks