compare 2 sheets and remove identical rows in sheet 2

**VBisgreat** · 12-10-2009, 12:04 PM

Hi all,

I need help comparing two sheets, if any row in sheet2 already exist in sheet 1 , then cut and paste it into a sheet3

Thank you very much

**JBeaucaire** · 12-10-2009, 01:23 PM

What is the comparison based on? A particular column?

"If ID in A1 on Sheet2 exists anywhere in column A on sheet1, then move the whole row from Sheet2 to Sheet3...repeat for all of Sheet2 column A values."

Something like that?

**VBisgreat** · 12-10-2009, 03:16 PM

compare the whole row, (the data in each cell of that row)

**jaslake** · 12-17-2009, 02:27 PM

Hi VBisgreat
This could be done with concatenation. How many columns are you talking about and how big are the files?
John

**xlcomparator** · 12-18-2009, 04:49 AM

I agree with jaslake : you should concatenate all the cells in one.

The syntax for the CONCATENATE function in Excel 2007 is:
= CONCATENATE ( text1, text2, ... text30 )
Text1, text2, ... text30 can be words, cell references, blank spaces, or numbers.

When it's done, you can use this comparison service to find identical lines in both files.
On step2, select the colum where you have made the concatenation in each file.