Hello all

This is not a freebie hat in hand.. I would happily pay to go on a
course but most courses are aligned to a specific content and asking
q's around a particular problem is sometimes not within parameters of
the course or simply because they dont know themsleves.

Anyhow I would like ask if you can help me. I have several worksheets
within the same workbook. I would like to set up a separate worksheet
that analyses data from these worksheets. I am only interested in a
specific column in all the other worksheets to see how many times a
partcular names appears?

The columns are all similar (ie all B) but every worksheet may vary in
column length (ie some are longer than others). The cells in that
column are formatted with borders. The info within each border
contains a name and beneath that an employee number ( ie occupies 2
cells)

I would like set up a comparison or index in a seperate worksheet that
analayses the data in this particular column to see how many times
the same name or employee number appears? (and if possible reference
from which worksheets it appears more than once)

Can you help with such a formula

I would be most grateful for any assistance?

Thank you