ExcelBanter - Counting text strings

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting text strings (https://www.excelbanter.com/excel-worksheet-functions/84385-counting-text-strings.html)

525047

Counting text strings

I have a large XLS which has columns containing multiple text initials
of people separated by commas and spaces within each column such as
below. I need to be able to count the number of occurrences of each
initial within a column into separate cells at the base of that column.
Any bright ideas?

COLUMN A
IN1, BJ2, BJ3
IN1,BJ3
BJ2 BJ3
BJ2

COUNTS
IN1=xxx
BJ2=xxx
BJ3=xxx

--
525047

JE McGimpsey

Counting text strings

One way:

=COUNTIF(A1:A100,"*BJ3*")

In article ,
525047 wrote:

I have a large XLS which has columns containing multiple text initials
of people separated by commas and spaces within each column such as
below. I need to be able to count the number of occurrences of each
initial within a column into separate cells at the base of that column.
Any bright ideas?

COLUMN A
IN1, BJ2, BJ3
IN1,BJ3
BJ2 BJ3
BJ2

COUNTS
IN1=xxx
BJ2=xxx
BJ3=xxx

All times are GMT +1. The time now is 09:04 AM.