Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting text
I am trying to count the number of rows where specific text strings appear.
If I found "jim" count it likewise, if I had "jack,jim" or "jim,john" count them as well, etc. A 1 jim 2 jack 3 jim 4 jack, jim 5 jim, john 6 Jack, john I'd like the answer to be, in this case 4. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting text
For a formula where the text string to find is hard coded into the
formula... =COUNTIF(A1:A600,"*jim*") If, say, the text string to find is in a cell (say B1 for this example), then use this formula... =COUNTIF(A1:A600,"*"&B1&"*") Adjust the range to suit your needs. -- Rick (MVP - Excel) "Bad_Shot" wrote in message ... I am trying to count the number of rows where specific text strings appear. If I found "jim" count it likewise, if I had "jack,jim" or "jim,john" count them as well, etc. A 1 jim 2 jack 3 jim 4 jack, jim 5 jim, john 6 Jack, john I'd like the answer to be, in this case 4. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting text
Thanks that works great.
"Bad_Shot" wrote: I am trying to count the number of rows where specific text strings appear. If I found "jim" count it likewise, if I had "jack,jim" or "jim,john" count them as well, etc. A 1 jim 2 jack 3 jim 4 jack, jim 5 jim, john 6 Jack, john I'd like the answer to be, in this case 4. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Counting | Excel Worksheet Functions | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Text Counting | Excel Discussion (Misc queries) | |||
counting text | Excel Worksheet Functions | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions |