filter

[david bloom]

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

 

[JE McGimpsey]

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

 

[Roger Govier]

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

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