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. |
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. |
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. |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com