| 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 |
| 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) | |||
Threaded Mode
