5
525047
I have a large XLS which has columns containing multiple text initial
of people separated by commas and spaces within each column such a
below. I need to be able to count the number of occurrences of eac
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=xx
of people separated by commas and spaces within each column such a
below. I need to be able to count the number of occurrences of eac
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=xx