To search Keywords

Set up AutoFilter on the column using the Contains... option.

Then list your keywords.

See:

http://www.contextures.com/xlautofilter01.html

Let's put your list in J1:J21 (except for the criteria about endings) and your data starts in A2 going down
In B2 enter this array formula (Array formulas require using CNTRL SHFT ENTER instead of ENTER. You'll see {} around your formula if done properly)

=SUM(--ISNUMBER(SEARCH($J$1:$J$21,A2)))+ OR(RIGHT(A2,2)={"PD","FD"})
dragged down. Then filter on column B > 0
Does that work for you?

ChemistB's formula was an array formula
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Here is your sample filled in.

non array version

Formula:

Please Login or Register  to view this content.