Excel Formulae
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 |
Excel Formulae
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 |
All times are GMT +1. The time now is 06:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com