You mean I'll "see" in, what was it, you're 3 months older then me, so I
then automatically become as "nuts" as you?<vbg
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CLR" wrote in message
...
Well, ok good,.........yours counts bob/bob/bob as 3 alright, but that
case-sensitivity stuff drives me nuts...........
when you get "older", you'll see............<g
Vaya con Dios,
Chuck, CABGx3
"RagDyer" wrote in message
...
Just responded to a similar question in the excel group where the OP had
*multiple* names in a cell.
A2 to A100 contains name data.
Enter name to count in C1.
Try this:
=SUMPRODUCT(LEN(A2:A100)-LEN(SUBSTITUTE(A2:A100,C1,"")))/LEN(C1)
NOW ... the caveat:
IF you enter "Fred" in C1, this will *also* count:
Freddy
Freddie
Frederico
Fredric
Frederick
BUT, it will *NOT* count:
Alfred
Wilfred
So watch out for the case sensitivity!
--
Regards,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"CLR" wrote in message
...
Very nice Dave.........I love that one but can never remember it
<g...........by the way, did you see that it only counts bob/bob/bob
as
just one "bob"? .......of course I doubt the OP will experience that
combination, but just a curiosity.....it's apparently counting cells
that
it
finds a bob in rather than the bob's themselves...........
Vaya con Dios,
Chuck, CABGx3
"Dave Peterson" wrote in message
...
maybe
=countif(a1:a10,"*bob*")
But if Bob is embedded in another name, it'll get counted.
Jim/Nabob/ralph
(I couldn't think of another name!)
James wrote:
To make it easy, I am trying to count the number of times the name
"Bob"
appears in a range of cells. Most of the time, "Bob" is the only
name
in
the
cell, so COUNTIF would work. However, sometimes there will be 2
names
in
the
same cell, like this: "Joe/Bob." What kind of formula can I use to
count
the
number of times "Bob" appears in a range of cells, including the
times
there
are 2 names in the same cell? With the COUNTIF function, it is
only
counting
the number of times "Bob" appears alone in a cell within the range
of
cells.
--
Dave Peterson
|