Hi Bob
"Bob Phillips" wrote in message
...
Hi Arvi,
Why did you say
=COUNTIF(A1:A96,"*"&"VVN"&"*")
instead of
=COUNTIF(A1:A96,"*VVN*")
just wondering?
:-))) Doctors are defining it as 'professinal cretinism', I think :-)))
Seriously, I'm a bit busy today, and with my head full my own problems. I
run trough my room for a moment, checked my question in programming NG, and
meanwhile wrote an answer to OP's question. And now I have to run again!
--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )
Bob
"Arvi Laanemets" wrote in message
...
Hi
=COUNTIF(A1:A96,"*"&"VVN"&"*")
--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )
"Paul W" wrote in message
...
I'm trying yo count the number of occurances of a string in a variable
string
e.g look for "VVN" in TDCS0/VVN/8375 or mycompany/VVN/8375 or even
mycompany/TDCS0/VVN/8375. The text does not appear in the same location
each
time. so what i am looking for is countif(a1/a96="VVN anywhere in this
string")
Excel 2002
Help !
|