Finding duplicates within several worksheets

N

Norm75

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.
 
J

joel

You could use countif

=countif(Sheet1!$A:$A,"IBM")+coutif(Sheet2!$A:$A,"IBM")+coutif(Sheet3!$A:$A,"IBM")
 
N

Norm75

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Formating bolded text exclusively. 0
Development combinations with exclusion of columns 0
Setting Scope of name ranges to particular worksheet 2
Comparing common values in either different worksheets or columns 1
How to copy workbook and formulas to read to the present month 2
Page numbering with Merged Document and IF statements 1

Top