Update column H based upon content in column B

[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

 

[Roger Govier]

Hi Ellen

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

 

[EllenM]

Thanks, Roger. Your script worked beautifully!!