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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Copy columns, but not hidden ones 3
SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN 2
LOOKUP problem 8
Can I have two conditions in a SUMIF? 5
Return Text based upon text matching 6
Count Columns, Return Content 5
Crazy multi-level parsing of data 3

Back
Top