remove duplicate information within Excel

[thehugedeal]

I have two excel worksheets in a workbook. I need to remove duplicate information between the two worksheets.

There is a lot of information within the worksheet. (Over 5000 rows of information)

Any Feedback???

 

[AnotherHiggins]

Please provide more information. Are you looking at a single column? Or are these records with multiple columns? Does one list a subset of the other, or might they both contain unique records that are not in the other?

[tt]_____
[blue]-John[/blue][/tt]


Help us help you. Please read FAQ181-2886 before posting.

 

[thehugedeal]

Two matching columns (Example, CONTRACT #).


Ex. Worksheet Number 1
Contract # Customer Name Phone #
5007 JHOAN TYRELO 999 999 9999
5031 RAYMOND MCINTOSH 999 999 9999
5061 MIKE VRIES 999 999 9999
5071 BILL HICKS 999 999 9999

Ex. Worksheet Number 2
Contract # Customer Name Phone #
5007 JHOAN TYRELO 999 999 9999 dup
5029 FRED HAYBILL 999 999 9999
5061 MIKE VRIES 999 999 9999 dup
5072 BOB HILLS 999 999 9999



I need to remove duplicate information between the two worksheets

 

[AnotherHiggins]

There are lots of ways to skin this cat.

In column D, use something like
[COLOR=blue white]=IF(ISERROR(VLOOKUP(A2,Sheet1!A:A,1,0)),"NEW","DUPE")[/color]
(replace Sheet1 with the actual sheet name)

Then sort by Column D - all of the Duplicates will be placed together with the word "DUPE" beside them. You can then delete those rows.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[macropod]

I'd probably go for COUNTIF - it's probably faster in this situation:
=COUNTIF(Sheet1!A:A,A2)
in Sheet2 copied down. Any duplicates of information between these two sheets will return a non-zero value. If the value is more than 1, it means you already have a duplicated entry on Sheet1!

If there is the possibility that some information appears on Sheet1 and not on Sheet2, replicate the process on Sheet1 with:
=COUNTIF(Sheet2!A:A,A2)

Cheers

 

[thehugedeal]

Thank You so much. Too good to be true!!!
Both worked like a charm.

You guys are the best!