Count Occurance of Text/Word in a Range

[Guest]

I have data that I have summarized where I need to count the occurance of
particular words (i.e. No Answer, Unconfirmed, Wrong Number). Is there a way
in a pivot table to do this? My results would look like this:

Cell A1 Cell B1
No Answer 345
Unconfirmed 128
Wrong Nunber 876

Becasue I am trying to summarize occurances of text, not numbers, I'm not
having any luck.

Any help would be greatly appreicated.

Joanthan

 

[Peo Sjoblom]

What's the problem you are having? Assume that the words are in A and they
have a header, select the range, do data>pivot table etc, then makes sure
the range is correct, click next and select layout and drag the header to
the row and the data field, that's it


--


Regards,


Peo Sjoblom