If you are using Excel 2007 then the easiest way to remove duplicates is:
- first put your data in the Table format (Insert - Table),
- second run the Remove Duplicates command from Tools ribbon of the Table
Tool Design.

One of the method to find the duplicate in your data is also:
- insert a pivot table on your data,
- put (drag or select) all column headings consecutively to the Row Labels
box,
- in the Field settings of the row labels choose None for Subtotals
- put (drag) any one of the column heading of your data into the values area
and chose Count as the agregate function
- in the Total column of the Pivot Table you see now if the record is a
duplicate (for me the best view is a Clasic Pivot Table layout, which you
can get if you right click pivot table, pick the pivot table Option, select
Display tab and then choose classic pivot table)

Ivan


"Jen_T" wrote in message
...
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?