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?

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Katie" wrote in message ...
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?

The list displays only ~1000 different entries.

On Thu, 10 Feb 2005 05:31:02 -0800, "Katie"
wrote:

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?