Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
excel formulae | Excel Worksheet Functions | |||
excel formulae | Excel Worksheet Functions | |||
using formulae in excel | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |