Filters

[Guest]

In Excel 2000, I have a spreadsheet that the filter worked fine. I used it
for a lot of "contains" filtering. It now appears that since I've added
additional text to some cells, when I do a filter, I'm not seeing all the
unique values in the drop down filter list. I've checked the area selected
and this is fine. Any recommendations?

 

[Ron de Bruin]

Hi Katie

There is a limit
http://www.contextures.com/xlautofilter02.html#Limits

You can use EasyFilter maybe (No problem there)
http://www.rondebruin.nl/easyfilter.htm

 

[Myrna Larson]

The list displays only ~1000 different entries.