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?