My commercial Excel add-in "XL Companion" can compare rows.
Its Match Rows feature returns the common and uncommon rows between two worksheets.
(also does other useful stuff)
Email direct and ask for the Free trial version.
Remove xxx from my email address... james.coneXXX at comcast.netXXX
Please provide your real name and geographic location.
--
Jim Cone
Portland, Oregon USA



"Jen_T"
wrote in message
I am not understanding. Will this compare the duplicate rows and tell me if
all columns match ? The rows will have the same id to identify if they are
duplicates in column A.

-snip-

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?