Solved Need more than 2 filter option in Excel sheet

September 10, 2016 at 06:52:46
Specs: Windows 7
In Excel, when you apply filter and choose the drop down, you find only two options under - Text Filters >> Custom Filters. You can not use more than 2 options for either Equal/Does No Equal, Exist/Does not exist, Contains/Does not contain etc.

Can you please suggest any macro where user can put more than 2 options, say 5 or 6?

For example, how can I choose 5 words in the option "contains" or "does not contain". Presently, it has only 2. If I have to work on 5 words then i have to first select 2 words, separate those rows and then work on 2 more and then finally last word.

I will appreciate your help and time in solving this.

Thank you.

See More: Need more than 2 filter option in Excel sheet

Report •

September 10, 2016 at 16:02:05
✔ Best Answer

Report •
Related Solutions

Ask Question