Deleting both duplicate rows in Excel.

[mdub72]

Hi,

I need to write a formula that identifies any rows where the Contract # and Order # columns are duplicates, then deletes both duplicate rows. Thanks

Michael

[robert111]

I think you need to write a macro. Start by switching on record macro, highlight a convenient blank row, delete it and stop the macro. You now have the code to delete a specific row.

Now write some code that starts at row 1 and compares the 2 cells in question. If they are equal, delete the row. If they are not, do nothing and move to the next row.

Please Login or Register  to view this content.

checks if A1=A2

the first 1 in each cells() needs to be count

Please Login or Register  to view this content.

you should be able to tailor to your situation