Hello all

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?

Thank you

See your other post - please do not multi-post.

Pete

On Jul 19, 2:36*am, wrote:
Hello all

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?

Thank you