count number of text in a column

[Guest]

Look at this then and tell me how I could get the report desired without
explictly naming each cell reference or actual name? My column 5800 cells
with multiple and single entries.

Unique Names Names used
Daniel Daniel, Celia
Celia Daniel
Sherlock Batman,Sherlock
Batman Daniel
Celia

Report then would be:
Daniel 3
Celia 2
Batman 1
Sherlock 1

 

[Dave Peterson]

Check your other thread.

Please don't start a new thread.

 

[Guest]

Try:

Assuming data in colums A & B then in column C row 2 (first row is header) put

=SUM(IF(ISNUMBER(FIND(A2,$B$2:$B$6,1)),1,0))

Enter with Ctrl+Shift+Enter

Copy down

 

[Guest]

Toppers,

WOW! Well close! What do I do if the length of the column I am trying to
count is different than the one with the unique list? I start to get a
strange count then as below:
names used count
daniel daniel, celia 2
celia celia 3
batman batman 1
sherlock daniel, celia 0
sherlock 4

 

[Guest]

try - entered with CSE:

=IF(A2<>"",SUM(,IF(ISNUMBER(FIND(A2,$B$2:$B$8,1)),1,0),0),"")

 

[Guest]

Toppers!

You are the best! If ever in the UK,let me know at
(e-mail address removed)
I owe you a pint!

 

[Guest]

If I could hire you for a day I would

try - entered with CSE:

=IF(A2<>"",SUM(,IF(ISNUMBER(FIND(A2,$B$2:$B$8,1)),1,0),0),"")

 

[Guest]

FYI, I am UK-based (near Portsmouth)!

Thanks for the feedback.