Thread: Duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jen_T Jen_T is offline
external usenet poster
 
Posts: 66
Default Duplicates

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?