Update column H based upon content in column B
 

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

Update column H based upon content in column B
 

Hi Ellen

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

--
Regards
Roger Govier

"EllenM" wrote in message
...
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

Update column H based upon content in column B
 

Thanks, Roger. Your script worked beautifully!!