Hi,
I have 2 columns.
Column A containing email addresses and other detail. This Column A is Alpha numeric and also has special characters like ',+ etc..
I have few keywords in Column B. Around 40.
Now I need to filter Column A where any of the 40 keywords are present ANYWHERE in the Cell.
For Example:
<tbody>
</tbody>
So from the above example as per the requirement.
I should see someone@somewhere.com because it "contains" the word "where" from Column B
Note: Column A and B may have special characters so it should also find them.
I have over 40 keywords like this and i dont want to repeat the exercise of going to Filter >> Containing etc...
Appreciate your suggestions.
Thanks!
netizenn
I have 2 columns.
Column A containing email addresses and other detail. This Column A is Alpha numeric and also has special characters like ',+ etc..
I have few keywords in Column B. Around 40.
Now I need to filter Column A where any of the 40 keywords are present ANYWHERE in the Cell.
For Example:
Column A | Column B |
someone@somewhere.com | amazing |
gotit@gotit.com | where |
<tbody>
</tbody>
So from the above example as per the requirement.
I should see someone@somewhere.com because it "contains" the word "where" from Column B
Note: Column A and B may have special characters so it should also find them.
I have over 40 keywords like this and i dont want to repeat the exercise of going to Filter >> Containing etc...
Appreciate your suggestions.
Thanks!
netizenn