Duplicate Records

[acrscraps]

I know, it's late and I can't think anymore. I have reports to run monthly and I need to remove the duplicate records. Columns A & B are the records from the previous month, from Column C on is the current report run. I am able to highlight the duplicates, but I need to know if there is a fast way for me to remove them.

 

[patel45]

show me your macro for highlight the duplicates, do you want delete the entire rows o only the cell ?

 

[smg]

You can remove them by inserting an additional column and using a standard formula:
=COUNTIF(INDIRECT(CONCATENATE("B1:B",ROW(B2)-1)),B2).

Then sort this column by values and delete every row which shows a value above 0.

If you want to use a macro follow what patel45 said.