Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicates within several worksheets
I have several worksheets with stock symbols listed according to various
criteria. I want to find the symbols that are common between the worksheets or some of the worksheets - for example, common in 2 out of 4 sheets or 3 out of 4 sheets. Is there a way of doing this. I am using Excel 2007 Many thanks. Norm. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicates within several worksheets
You could use countif
=countif(Sheet1!$A:$A,"IBM")+coutif(Sheet2!$A:$A," IBM")+coutif(Sheet3!$A:$A,"IBM") "Norm75" wrote: I have several worksheets with stock symbols listed according to various criteria. I want to find the symbols that are common between the worksheets or some of the worksheets - for example, common in 2 out of 4 sheets or 3 out of 4 sheets. Is there a way of doing this. I am using Excel 2007 Many thanks. Norm. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicates within several worksheets
Thanks, Joel. I'll give it a try. I have a huge number but it will be worth
setting it up this way. Many thanks. Norm. "joel" wrote: You could use countif =countif(Sheet1!$A:$A,"IBM")+coutif(Sheet2!$A:$A," IBM")+coutif(Sheet3!$A:$A,"IBM") "Norm75" wrote: I have several worksheets with stock symbols listed according to various criteria. I want to find the symbols that are common between the worksheets or some of the worksheets - for example, common in 2 out of 4 sheets or 3 out of 4 sheets. Is there a way of doing this. I am using Excel 2007 Many thanks. Norm. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Duplicates | Excel Discussion (Misc queries) | |||
Finding duplicates | Excel Discussion (Misc queries) | |||
Finding duplicates in 2 worksheets | Excel Worksheet Functions | |||
Finding Duplicates | Excel Worksheet Functions | |||
Finding duplicates | Excel Worksheet Functions |