Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace Part of a Function
=COUNTIF(F:F,"Bent")
=COUNTIF(F:F,"Binding") =COUNTIF(F:F,"Broken") So I have these formulas that will count the occurences of words in column F. The formula resides in column L. I need to replace the word inside the quotes with a new word or a new phrase based upon a list in column K. How do I go about doing that? I am assuming that the formula would involve Search, Replace, & some concatenation but I am not sure how to assemble it. I have been manually replacing a new word or phrase between the quotes and still have a large number of them to complete. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace Part of a Function
I'm not completely sure what you are asking. Are you saying you have a list
of words in Column K and you want to apply the COUNTIF function against each word? If so, just reference the first cell in Column K and then copy the formula down. That is, put this in Column L.... =COUNTIF(F:F,K1) and then copy it down for as many rows as are in the list in Column K. Rick "Walter" wrote in message ... =COUNTIF(F:F,"Bent") =COUNTIF(F:F,"Binding") =COUNTIF(F:F,"Broken") So I have these formulas that will count the occurences of words in column F. The formula resides in column L. I need to replace the word inside the quotes with a new word or a new phrase based upon a list in column K. How do I go about doing that? I am assuming that the formula would involve Search, Replace, & some concatenation but I am not sure how to assemble it. I have been manually replacing a new word or phrase between the quotes and still have a large number of them to complete. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace Part of a Function
If 'Bent' is in K1,
=COUNTIF(F:F,K1) "Walter" wrote in message ... =COUNTIF(F:F,"Bent") =COUNTIF(F:F,"Binding") =COUNTIF(F:F,"Broken") So I have these formulas that will count the occurences of words in column F. The formula resides in column L. I need to replace the word inside the quotes with a new word or a new phrase based upon a list in column K. How do I go about doing that? I am assuming that the formula would involve Search, Replace, & some concatenation but I am not sure how to assemble it. I have been manually replacing a new word or phrase between the quotes and still have a large number of them to complete. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPLACE PART OF CELL WITH FORMATTED TEXT | Excel Worksheet Functions | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Find and replace part of a text string | Excel Discussion (Misc queries) | |||
Q: DDE Link - Replace Part of the Formula | Excel Worksheet Functions | |||
How do I find and replace part of a hyperlink that isn't visible? | Excel Discussion (Misc queries) |