Hello,
I ran across this demonstration of using a pviot table to do a countif but am unsure what the steps are. Maybe someone can assist?
Scenario:
Data
One Two Three
Three Two
One
The data is as above, one column with a header and three cells with text. The target is to get the number of unique words across the cells and their counts.
So from this example the result should be:
One 2
Two 2
Three 2
since each single word was used twice. I believe that this can be accomplished with a pivot table without knowing the individual words a priori (e.g. One, Two, and Three).
Any thoughts.
abousetta
Bookmarks