| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of times a specific word appears in a single cell
Hi,
I am using a function (=COUNTIF(data,"*"&nn&"*") that searches a range of cells and tells me how many times "nn" appears. It's fine. However, if "nn" appears twice in a single cell it is only counted once - not twice. How do I have "nn" (or anything else) counted for the number of times it appears in a range including it appearing twice (or more times) in a single cell? -- Ken Curtis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of times a word appears | Excel Worksheet Functions | |||
| count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
| Counting the number of times a word appears 'anywhere' on a page | New Users to Excel | |||
| Counting the number of times a specific character appears in a cell | Excel Worksheet Functions | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
Threaded Mode
