Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
Hello, I have a user with a Spreadsheet with a list of names. When Autofilter
is used some of the names are missing on the list. When the list is sorted in asscending order the name then appears on the list. Does anyone know whether this is a known bug in Excel or has anyone come accross this before? It's not a problem really, but it would be nice to know. Chris. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
Hi Kentucky
Are there more than 1000 names in the list? There is a limit to the number of names displayed with Autofilter. Debra Dalgleish has some workarounds at her site http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Kentucky" wrote in message ... Hello, I have a user with a Spreadsheet with a list of names. When Autofilter is used some of the names are missing on the list. When the list is sorted in asscending order the name then appears on the list. Does anyone know whether this is a known bug in Excel or has anyone come accross this before? It's not a problem really, but it would be nice to know. Chris. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
There's a 1000 limit on the number of unique items which can appear in the
autofilter's droplist. Debra's page has some cool workarounds: http://www.contextures.com/xlautofilter02.html#Limits If the above is not the issue, try selecting the entire col(s) before you re-apply the autofilter (there could be some blank rows within the data) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kentucky" wrote: Hello, I have a user with a Spreadsheet with a list of names. When Autofilter is used some of the names are missing on the list. When the list is sorted in asscending order the name then appears on the list. Does anyone know whether this is a known bug in Excel or has anyone come accross this before? It's not a problem really, but it would be nice to know. Chris. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
Hi Max,
Thank you, I have been to the contextures site below and found a solution to the problem. I will show this to the user. Regards, Chris. "Max" wrote: There's a 1000 limit on the number of unique items which can appear in the autofilter's droplist. Debra's page has some cool workarounds: http://www.contextures.com/xlautofilter02.html#Limits If the above is not the issue, try selecting the entire col(s) before you re-apply the autofilter (there could be some blank rows within the data) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kentucky" wrote: Hello, I have a user with a Spreadsheet with a list of names. When Autofilter is used some of the names are missing on the list. When the list is sorted in asscending order the name then appears on the list. Does anyone know whether this is a known bug in Excel or has anyone come accross this before? It's not a problem really, but it would be nice to know. Chris. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
You're welcome, Chris !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kentucky" wrote: Hi Max, Thank you, I have been to the contextures site below and found a solution to the problem. I will show this to the user. Regards, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Auto Filter Function | Excel Worksheet Functions | |||
URGENT !! Auto Filter | Excel Discussion (Misc queries) | |||
URGENT !! Auto Filter | Excel Discussion (Misc queries) | |||
Auto filter in Excel | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions |