| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update column H based upon content in column B
Thanks, Roger. Your script worked beautifully!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I update a column and create new rows for new column cells | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| how to create a chart based on the content of a column | Excel Discussion (Misc queries) | |||
| How do I update Column #1 based on specific value of column #2? | Excel Worksheet Functions | |||
Hybrid Mode
