Forum Discussion
Using pivot table to count occurrence of text
Hello. I am trying to find out how many times a word/combination of words occurs in a spreadsheet. I tried the COUNTIF function, but it only calculated how many times the word(s) occurred when they...
HansVogelaar Many, many thanks for this insight. I tried it and got a different count than when I counted manually, but I will continue to work with it to try to figure out why.
Out of curiosity, would a pivot table also be able to help me determine a count of occurrences? And if so, are you able to tell me which field I would place in which boxes in the pivot table builder to get my total?
I sincerely appreciate your help!
I'm not sure why PivotTable is better, but as variant if we have such tables
load the to data model and add calculated column to Word table
and use it in PivotTable.
SergeiBaklan Thanks very much for your help - I will give this a try!