Update column H based upon content in column B

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello,
I'd like a "keep" to be added to column H where you find *opa-g* in column
B. How would that be done?

Thanks,
Ellen
 
Hi Ellen

One way
in H2 enter
=IF(COUNTIF(B2,"*opa-g*"),"keep","")
Copy down as far as required
 
Back
Top