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    May 21, 2015
question  by Anton Finneran:!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