Here's some AMAZING code to remove duplicate rows of data in Excel...
This code flat out rocks! It has saved me from having to spend hundreds of hours in manual data delete 'hell'.
De-Dups redundant rows in MS Excel based on column A1 to the end of the data
Paste the following code in a VB Macro in an Excel workbook
Sub DeDup()
Dim RowNdx As Long
For RowNdx = Range("A1").End(xlDown).Row To 2 Step -1
If Cells(RowNdx, "A").Value = Cells(RowNdx - 1, "A").Value Then
If Cells(RowNdx, "B").Value <= Cells(RowNdx - 1, "B").Value Then
Rows(RowNdx).Delete
Else
Rows(RowNdx - 1).Delete
End If
End If
Next RowNdx
End Sub
