Hi Dodo,

OK, let's see...the name/word 'Donnelly' is in numerous cells in column 'E'
i.e. 'E6' onwards...I've entered your formula '=COUNTIF(A:D,"*"&E3&"*")' into
cell 'E2' and 'Donnelly' into cell 'E3'...but I am still getting '0' in cell
'E2'.

Close but no cigar!

Thanks for the help,
Paul


"Dodo" wrote:

"?B?ZG9ubmVyczY=?=" wrote in
:

Hi Dodo (fantastic name),

Yeh, I'm extinct! ;-)))

I entered your formula into cell 'E2' (changed the 'A2' to 'E2' and
entered "Donnelly"...no joy...see my reply to the first response by
Paul Black for some clarity...


I suppose your separator is , (if not replace the , in the following
example with your local separator which here in NL is ; which I forgot to
replace in my earlier examples, sorry).

You have to enter the formula in a cell outside the area you are searching!

So, suppose the search range is columns A:D (this will search the columns
top to bottom; if not desired you have to make it a range like e.g.
A2:D34).

Then you can enter in cell E2:

=COUNTIF(A:D,"*"&E3&"*")

Then in cell E3 you can enter the search term: Donnelly (no quotes!) and
you will see the result in cell E2.
So, do not enter the search term in the same cell as where you entered the
formula!
(If that is what happened.)

I do not know your level of experience with Excel so in case I made some
assumptions about your Excel skills that irritate you, I apologize in
advance!


--

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