Count Occurance of Text/Word in a Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count no of times a letter occurs in a text string 4
Count specific characters in a cell 7
Counting Occurances across a range of sheets 8
Searching and counting text in a spreadsheet 3
count specific text that occurs in a range of cells 16
Counting the number of times a character occurs in a cell 1
Count of different occurances 3
Count Occurances of String in a Column? 4

Back
Top