Jim, thank you for the addin. I was working with it a bit and had a question.
In my worksheet I have 1700 rows, 850 are duplicates, I need the addin to
look at each of the two rows in the worksheet that are duplcaites and than
look at each column to indicate what is, if any does not match for the two
records. Do I need to look at the two rows one at a time, another words run
the addin 850 times?


"Jim Cone" wrote:


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?