I have a suggestions column in a survey feedback, that's being pushed from the survey provider to a Google Spreadsheet. I'm trying to do a bit of wording analysis on it. For example, I'm trying to count the number of occurrences of the word "Difficult".
I already found a way by concatenating all the feedback and splitting it into cells and then comparing the cells with the word, but this is not scalable. It looks like Google has a limit on the amount of words I can squish into one cell and so the concatenate function is giving me an error. I'm hoping to use the
FIND function, but I can't seem to figure out how to count the words in the column.
Here's an example of what I'm trying to do: counting of words