Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|