FindNonDuplicateRecordsInWorksheets
 

I am using Excel 2007. I have worksheet 1 and 2, with customer records
in each worksheet. There is a custid in each record. I would like to
look at the records in sheet 1 and compare to sheet 2, if the custid
doesn' t exist in sheet 2 then print the record into sheet 3. Can I do
this with Excel?

Thanks

FindNonDuplicateRecordsInWorksheets
 

use the MATCH() function, then sort. Anything not matched will show errros at
the botton (if you alpha sort) ...just copy this list to the 3rd sheet
no need for code

"mc" wrote:

I am using Excel 2007. I have worksheet 1 and 2, with customer records
in each worksheet. There is a custid in each record. I would like to
look at the records in sheet 1 and compare to sheet 2, if the custid
doesn' t exist in sheet 2 then print the record into sheet 3. Can I do
this with Excel?

Thanks

FindNonDuplicateRecordsInWorksheets
 

Patrick Molloy wrote:
use the MATCH() function, then sort. Anything not matched will show errros at
the botton (if you alpha sort) ...just copy this list to the 3rd sheet
no need for code

"mc" wrote:

I am using Excel 2007. I have worksheet 1 and 2, with customer records
in each worksheet. There is a custid in each record. I would like to
look at the records in sheet 1 and compare to sheet 2, if the custid
doesn' t exist in sheet 2 then print the record into sheet 3. Can I do
this with Excel?

Thanks

Patrick:

How would I identify the sheets in this function? Would I put the
following function in a column in sheet 3 to do the comaprison and copy
the record?
=MATCH(sheet1:B2:B25,sheet2:B2:B35,0)


Thanks

FindNonDuplicateRecordsInWorksheets
 

almost. you can enter it as an array formula
if you're using sheet1 and want to match whats' in column A with sheet2,
column B

{ =MATCH(A1:A100,Sheet2!B1:B100,FALSE) }

or if you don't use a formula array, jus =MATCH(A1,Sheet2!$B$1:$B$100,FALSE)
and replicate down for all values in A.
The advantage of the latter is that you can sort the table





"mc" wrote:

Patrick Molloy wrote:
use the MATCH() function, then sort. Anything not matched will show errros at
the botton (if you alpha sort) ...just copy this list to the 3rd sheet
no need for code

"mc" wrote:

I am using Excel 2007. I have worksheet 1 and 2, with customer records
in each worksheet. There is a custid in each record. I would like to
look at the records in sheet 1 and compare to sheet 2, if the custid
doesn' t exist in sheet 2 then print the record into sheet 3. Can I do
this with Excel?

Thanks

Patrick:

How would I identify the sheets in this function? Would I put the
following function in a column in sheet 3 to do the comaprison and copy
the record?
=MATCH(sheet1:B2:B25,sheet2:B2:B35,0)


Thanks