autofilter

[Guest]

hi community

i created an autofilter list from a cell range
and
example of the list of label ....

apple
banana
ciku
durian

however when using the "Custom" at the Autofilter, some of the name do not
appear,

can someone enlighten me on what is wrong ?

thanks community

 

[Peo Sjoblom]

Do you have over 1000 items in the list, if not did you select the whole
list before applying the filter?


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Guest]

yes! the list is over 1000 items and yes! i selected all the list item before
applying the list feature!!!!

and

when i set as a Pivot Table field list, the item that is "missed" out, did
appear in the Pivot Table display...

so what is happening to the custom list...

thanks for the assistance

thanks community as well

 

[Peo Sjoblom]

autofilter pre excel 2007 can only display up to 1000 items

http://www.contextures.com/xlautofilter02.html#Limits


Debra Dalgleish has a workaround here

http://www.contextures.com/xlautofilter02.html#Limits


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Guest]

thanks for the info Peo Sjoblom

thanks community