Tuesday, June 7, 2016

yogi_Find Different Words And Their Respective Count In A LIST OF Phrases

Google Spreadsheet   Post  #2070
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-07-2016
question by: Manny Sousera:

I have a column with whole sentences in each cell. What I need is to count the frequency of each word in the column, and to display the results in a new column (in descending order of frequency). An example is: (row 1) The apple fell from the tree. (row 2) The dog chased after the cat. (row 3) The cat ran up the tree. The formula would show (in a new column): The - 6 Cat - 2 Tree -2 Chased - 1 ... Etc. Preferably there would be a way to include a list of stopwords (so that 'the, or, if', etc, were not included in the count). I would provide the stopwords, perhaps in a separate column within the spreadsheet. I am stumped - I have looked up and down the net for a solution, without luck.