You can send the file to me he

pashust <at auditel.net

Change the obvious.

Pete

On Jul 21, 12:41*am, wrote:

Thankyou for that

However, I have now entered that and it shows a value of 0. This is
incorrect as i purposely set up two worksheets that had same details
in column A..

The COUNTIF function surely only counts? I would like a function that
determines how many times the same name appears in the same column of
each worksheet and what that name(s) is/are.

I apogise *and am grateful 4 ur help. Might it be easier if I could
telephone you to explain my enqury? I ma happy to give you my number .

Ifou cannot help any further it is ok. I will understand and wish u
the best

Hal