Thread: Counting text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bad_Shot[_2_] Bad_Shot[_2_] is offline
external usenet poster
 
Posts: 16
Default 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.