Thanks Bob,

Mmm, no luck though, this has gone a bit over my head...

"Bob Phillips" wrote:

In that instance it would be more beneficial to the OP to give specific
examples, such as

=COUNTIF(A2:Z35000,"*text*")

or if the texct is in a cell, then use

=COUNTIF(A2:Z35000;"*"&B1&"*")

otherwise the OP might be confused.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dodo" wrote in message
. ..
"Biff" wrote in news:OX$DXA5oFHA.2472
@tk2msftngp13.phx.gbl:

Hi!

=COUNTIF(A2:Z35000;"*"&"text"&"*")

Less "cryptic":

=COUNTIF(A2:Z35000,"*text*")


Right!

But with my example you can replace "text" with e.g B1 to search for the
text entered in B1. ;-)))


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)