FindNonDuplicateRecordsInWorksheets

M

mc

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
 
P

Patrick Molloy

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
 
M

mc

Patrick said:
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
Click to expand...
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
 
P

Patrick Molloy

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
 
Top