Thread: Counting items in strings
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Slim Slender[_2_] Slim Slender[_2_] is offline
external usenet poster
  
Posts: 39
Default Counting items in strings
I have a table with a column that reads:
Br
Corr
SAP
SAP
Br, Gov
Comp
Br, SAP
Comp
Comp, Gov
Br
Br, SAP


I want to count the Br's and come up with 5 and not 2. I've tried a
PivotTable and I've tried Countif.
Any ideas.
Reply With QuoteReply With Quote