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?