View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Autofilter list options

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

"red1" wrote:

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