Tuesday, June 14, 2011

yogi_Count How Many Times Various Words Show Up In A Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

BeFunk said:
count how many time various words show up in a column and assigne each word a cell with the total.
in the following, I have words in column A starting with row 2 down,
list of unique words in column B starting with row 2 down
in column C starting with row 2 down, I have the number of times each word occurs in column A
and the total count of all the words in column A is in cell C1