Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurance of Text/Word in a Range
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 -- JP Hosler Fairfield - NJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurance of Text/Word in a Range
What's the problem you are having? Assume that the words are in A and they
have a header, select the range, do datapivot 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 "JPH" wrote in message ... 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 -- JP Hosler Fairfield - NJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Occurance | Excel Worksheet Functions | |||
count number of occurances of a word in a range | Excel Worksheet Functions | |||
Find last occurance of text in range | Excel Worksheet Functions | |||
Count the occurance of a value x a value in another cell in excel | Excel Worksheet Functions | |||
SPECIFIC WORD COUNT FROM A RANGE | Excel Discussion (Misc queries) |