Delete duplicate rows in Excel

**vijay2482** · 10-28-2009, 05:21 AM

Hi all,

I have a excel file which contains dublicate rows.
The duplicate rows can be identified based on few cell/column values.
I need a macro to delete the duplicate rows when the below condition is satisfied:
let us consider row 5 and row 6:
If column 7,12,13,16,17,18,19,23,24,27,28,29,30 in row 5 = row 6 then row 6 has to be deleted.
This condition has to be followed for all other rows in the excel used range.
Have attached the sample workbook.

Any help will be helpful.
Thanks in Advance.

**DonkeyOte** · 10-28-2009, 05:54 AM

Not entirely sure I follow the requirements but perhaps along the lines of:

Please Login or Register  to view this content.

NOTE: run on copy of file/sheet when testing given deleting information

**vijay2482** · 10-28-2009, 06:37 AM

Thanks a lot.
Will give it a try and come back.

**johnjohns** · 10-28-2009, 07:47 AM

I think there is a simple solution for this. In an empty column, concatenate all those specific column values. Then in the next column, find the occurance of the joined values using COUNTIF function. Delete the rows where formulas give a value greater than 1. Do this from bottom to top. See the attached file