|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.