Filtering with multiple keyword in another column "containing" a specific part of the text

[netizenn]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]someone@somewhere.com[/TD]
[TD]amazing[/TD]
[/TR]
[TR]
[TD]gotit@gotit.com[/TD]
[TD]where[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Comfy]

Advanced filter works with *

Excel 2010
	A	B
1	email	email
2	someone@somewhere.Com	*amazing*
3	gotit@gotit.com	*where*
Sheet1

Excel 2010
	A	B
1	email	email
2	someone@somewhere.Com	*amazing*
Sheet1

 

[netizenn]

Hei thanks for the reply...

However...
I have Outlook 2007.

Let me ask you again...

I have the following keywords in Column B

START START

albert
jack
no-reply
subscribe
subscription
register
new
,
=
"
/

END END

Now in Column A I have all the emails

I wish to filter ONLY the email where any of the above words are present anywhere in the email
Example:
iknowalbertoneil@dotcom.com

because the above email has the word "albert" which is listed in Column B it should filter it and show...


Like above i have many keywords which needs to match and filter and show...ALL AT ONCE...


Hope i have elaborated it well.


Thanks!
Netizenn.[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Comfy]

It should still work.

This might help:

Filter by using advanced criteria - Excel - Office.com

 

[netizenn]

I guess I found the trick this surely is the trick...

Example:
Filter Column A using set of multiple keywords in Column B

Try this link: http://www.mrexcel.com/forum/excel-questions/85439-find-specific-text.html

=INDEX(D$1:D$3,MATCH(1,(--ISNUMBER(SEARCH(D$1:D$3,A1))),0),0)


Thanks!
netizenn

 

[Aladin Akyurek]

I guess I found the trick this surely is the trick...

Example:
Filter Column A using set of multiple keywords in Column B

Try this link: http://www.mrexcel.com/forum/excel-questions/85439-find-specific-text.html

=INDEX(D$1:D$3,MATCH(1,(--ISNUMBER(SEARCH(D$1:D$3,A1))),0),0)


Thanks!
netizenn

Try also...

=LOOKUP(9.99999999999999E+307,SEARCH(D$1:D$3,A1),D$1:D$3)