G Guest Jan 28, 2004 #1 why does filter not show every choice in the column below...sometimes it does, but many times some of the cell's contents do not appear
why does filter not show every choice in the column below...sometimes it does, but many times some of the cell's contents do not appear
J JE McGimpsey Jan 28, 2004 #2 Autofilter will show only the first 1,000 unique entires. For a workaround, see Debra Dalgleish's Limits to Dropdown Lists http://contextures.com/xlautofilter02.html#Limits
Autofilter will show only the first 1,000 unique entires. For a workaround, see Debra Dalgleish's Limits to Dropdown Lists http://contextures.com/xlautofilter02.html#Limits
R Roger Govier Jan 28, 2004 #3 Hi David Autofilter has a limit of 1000 items. Take a look at Debra Dalgleish's site for information on ways around this. http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier david bloom said: why does filter not show every choice in the column below...sometimes it Click to expand... does, but many times some of the cell's contents do not appear
Hi David Autofilter has a limit of 1000 items. Take a look at Debra Dalgleish's site for information on ways around this. http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier david bloom said: why does filter not show every choice in the column below...sometimes it Click to expand... does, but many times some of the cell's contents do not appear
