search for certain words

  • Thread starter Thread starter bmiller
  • Start date Start date
B

bmiller

What I am looking to do is rather basic (I would hope). One colum
contains a list of names. I need to search through each cell in thi
column. Then, if “dc” or “sir” appear anywhere in the cell that entir
row/record gets copied to a new sheet.

I have a macro written to copy the records to another sheet. I can’
seem to find out how to search the cell for certain words.

bmille
 
You could use a formula like:

=(SUM(COUNTIF(A1,{"*dc*","*sir*"})))>0

And copy the rows with True in them.
 
Back
Top