how do I find duplicate information on 2 sheets using a formula?
 

I have two lists of parts on two different pages in a workbook. I need to
find a formula to enter on a 3rd worksheet to be able to see which part
numbers are duplicated and which are not.

how do I find duplicate information on 2 sheets using a formula?
 

Hi,
Take a look at CPearson Web

http://www.cpearson.com/excel/ListFunctions.aspx


"KaseyJo" wrote:

I have two lists of parts on two different pages in a workbook. I need to
find a formula to enter on a 3rd worksheet to be able to see which part
numbers are duplicated and which are not.