counting of names
 

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

counting of names
 

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

--
---
HTH

Bob


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



"ekkeindoha" wrote in message
...
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

counting of names
 

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

"ekkeindoha" wrote:

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