Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter list options
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter list options
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 "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
validation list with drop down list of options?? | Excel Worksheet Functions | |||
Running a macro for each item in an Autofilter list | Excel Discussion (Misc queries) | |||
Update master list with other lists | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |