Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
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 :) -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
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) "oldLearner57" wrote in message ... 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 :) -- oldLearner57 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
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 :) -- oldLearner57 "Peo Sjoblom" wrote: 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) "oldLearner57" wrote in message ... 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 :) -- oldLearner57 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
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) "oldLearner57" wrote in message ... 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 :) -- oldLearner57 "Peo Sjoblom" wrote: 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) "oldLearner57" wrote in message ... 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 :) -- oldLearner57 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter
thanks for the info Peo Sjoblom :)
thanks community :) -- oldLearner57 "Peo Sjoblom" wrote: 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) "oldLearner57" wrote in message ... 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 :) -- oldLearner57 "Peo Sjoblom" wrote: 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) "oldLearner57" wrote in message ... 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 :) -- oldLearner57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter | Excel Discussion (Misc queries) | |||
Autofilter and IRM | Excel Discussion (Misc queries) | |||
Autofilter | Excel Worksheet Functions | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Autofilter | New Users to Excel |