I am not understanding. Will this compare the duplicatea rows and tell me if
all columns match ? The rows will have the same id to identify if they are
duplicates in colmn A.

"slarbie" wrote:

Check out the VBA RowDifferences Method: (pasted from help file)

RowDifferences Method
Returns a Range object that represents all the cells whose contents are
different from those of the comparison cell in each row.

expression.RowDifferences(Comparison)
expression Required. An expression that returns a range containing the
cells to be compared.

Comparison Required Variant. A single cell to compare with the specified
range.

Example
This example selects the cells in row one on Sheet1 whose contents are
different from those of cell D1.

Worksheets("Sheet1").Activate
Set c1 = ActiveSheet.Rows(1).RowDifferences( _
comparison:=ActiveSheet.Range("D1"))
c1.Select



"Jen_T" wrote:

Is there a way to check if duplicate rows have the same information in both ?
I have about 850 of data that is duplicated, giving me a total of 1,700
rows. Both sets of data have the same column headings, I need to check if
they have the same information for each duplicate. Is there an easy way to do
this besides manually ?

Example:
Column A in one record is it identical to column A in duplicate record, than
column B for the same record is it a duplicate in column B in the duplicate
record?