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