• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. F

    Formula for finding a word phrase in an entire column/row

    Hi Faseeh, Thanks a lot for the help. In this formula: =COUNTIF($A$1:$A$4,"*"&"Chandoo"&"*") Instead of typing 'Chandoo' in the formula, can I give the cell reference of this word? Because, since there are too many words that I have, I cannot type each of the word in the formula. I have...
  2. F

    Formula for finding a word phrase in an entire column/row

    I have a range of cells with too many words in rows and columns. I want to find how many times a particular "Word Phrase" is repeated in the entire range of cells. For example: Cell ranging from A1 to A200 have an average of 25 words in each cell. Now, I have a list of phrase eg. 'Awesome In...
Back
Top