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

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to find and log all formula errors on all sheets	Adnan	Microsoft Excel Programming	9	18th Aug 2008 08:40 AM
Formula for Avoiding totals of Duplicate Information	Garbage Man	Microsoft Excel Misc	1	15th Jan 2008 03:16 PM
Find Duplicate Information	=?Utf-8?B?Um9i?=	Microsoft Excel Misc	2	1st Aug 2007 05:48 AM
find duplicate entry and replace across sheets	splat	Microsoft Excel Programming	2	15th Mar 2007 11:39 AM
FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA	=?Utf-8?B?Z2ti?=	Microsoft Excel Misc	2	7th Dec 2006 08:59 AM