Counting items in strings

  • Thread starter Thread starter Slim Slender
  • Start date Start date
S

Slim Slender

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.
 
Back
Top