advanced filter

[lemery]

I have a column of 5000 job titles, I would like to search the column for any of 20 different words. If it contain any of the 20 words, I will delete them.

I see how I can filter up to 2 words using the customer filter and using the word contains. How do I do this for up to 20 words?

 

[Comfy]

how do I make the search "Contains" instead of "exact"?

You use asterisks.....

Please paste your data and your filter criteria (including the header rows) here.

 

[lemery]

You use asterisks.....

Please paste your data and your filter criteria (including the header rows) here.

Here is the part of the column, it is surrounded on both sides by data:

Position

Owner/Founder

Co-Program Medical Director

Physician

Physician

Hospitalist RN

Clinical Research Fellow - Nephrology

General Pediatrician

Pediatric cardiology fellow

hospitalist

Head, Clinical Research Cold, Cough and Respiratory Disease

MD - Hospitalist

Hospitalist

Primary Care Internal Medicine Physician

Hospitalist Physician

Hospitalist

Physician

Chief Medical Officer

Physician/Pediatric Hospitalist I want to seach first to filter for anything wiht these words os I can delete them, to not also delete the search informatioin, I have to have it on another sheet: position =?*nurse* =?*recruit* =?*np* =?*physician assistant* =?*coordinator* =?*scheduler* =?*administration* =?*billing* =?*arnp* =?*staffing* =?*rn* =?*aprn* =?*executive assistant* Then I want to run a search for all exact of these same titles to see if they say the below words (any of them. I've tried two differnt ways: (Thisis written ="=Hospitalist" position =Hospitalist =Pediatric Hospitalist =MD Hospitalist =Hospitalist MD =physician Hospitalist =Hospitalist physician <colgroup><col width="67" style="width:50pt"> </colgroup><tbody> </tbody> and like this (written ="=EXACT(Hospitalist)") position =EXACT(Hospitalist) =EXACT(Hospitalist MD) =EXACT(physician Hospitalist) =EXACT(Hospitalist physician) =EXACT(Pediatric Hospitalist) =EXACT(MD Hospitalist) <colgroup><col width="67" style="width:50pt"> </colgroup><tbody> </tbody> <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>