Thursday, May 21, 2015

yogi_Count Row By Number Of Instances Of Specified Phrase In Rows Of Column A


                                           Google Spreadsheet   Post  #1960
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 21, 2015
question  by Anton Finneran: 
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/WrOQ3KvROMY

How to count multiple iterations of a text string in a cell
Hi all

How to I count the number of times a certain text string is found within a cell

For example - the string "ABC"

If cell A1  = "ABC XYZ ABC", I would want the result to be returned to be 2 or
if cell A2 = "XYZ AA ABC ABC ABC", the result would be 3

Ultimately, I want to count the iterations of the text string "ABC" in a range of cells - say column A

Any advice would be appreciated

Thanks
Anton
------------------------------------------------------------------------------------------------------------------