But with my example you can replace "text" with e.g B1 to search for the
text entered in B1. ;-)))
True!
Biff
"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)
|