Autofilter list options

R

red1

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 ->>>>>Help ASAP Thanks
 
C

CLR

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
 
E

Elkar

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 "Equal
to" or "Does Not Equal" and leave the criteria blank.

HTH,
Elkar
 
Top