But you may want to explain your question in more detail.
If the filter isn't including all the rows in the range you want filtered, I'd
suggest that you turn it off, then select the range to filter, then re-apply the
filter.
If you're talking about the number of items seen in the dropdown..........
1000 unique items is the limit.
If you have more than that you will have to use the Custom feature.
equal to or contains or whatever.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
