counting of names

E

ekkeindoha

Good day,
I would like to count names automaticly for instance,
A B
John & Pete 2
John 1

If somone can help with a formula

Thx
 
B

Bob Phillips

=:LEN(A1)+LEN(SUBSTITUTE(A1,"&",""))+1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
M

Mike H

Hi,

It looks from your example as if both names could appear in the same cell so
try this for John with the obvious change for Pete. Note this isn't case
sensitive and its and array so enter with
CTRL+Shift+Enter

=COUNT(SEARCH("john",A1:A25,1))

Mike
 
Top