Update column H based upon content in column B

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
 
R

Roger Govier

Hi Ellen

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