Deleting Duplicated Rows

Hi everyone,

I have the following code to delete the duplicated rows depending on column B values in each row:

Please Login or Register  to view this content.

I would like to develop this code to check the opposite cell in Column C for each duplicated cell in Column B >>

If the opposite cell in column D is duplicated then the row should be deleted ..

and if the opposite cell in column D is not duplicated then the row should not be deleted

for example:

if the value of cell B5 is 1000
and the value of cell B10 is 1000

and the value of cell C5 is 5
and the value of cell C10 is 5

Then Row Number 5 should be deleted.

But if the value of cell B5 is 1000
and the value of cell B10 is 1000

and the value of cell C5 is 5
and the value of cell C10 is 10

None of these two rows should be deleted

I hope that my request and example are clear for all,

Thanks,

Hi,

Working on the logic from your code:

Please Login or Register  to view this content.

Would performing the same test to column C once the condition on column B has been met work:

Please Login or Register  to view this content.

Hope this helps.

Ben

Try this code:

Please Login or Register  to view this content.

Regards,
Antonio

Hi all,

Mr. ben77 .. your code is very simple and short, but it sometimes deletes unpuplicated rows.

Originally Posted by antoka05

Try this code:

Please Login or Register  to view this content.

Regards,
Antonio

Thank you so much Mr. antoka05 .. that is exactly what I need ..

I added one additional row to the code in order to disable the screen updating while running the code

I also change to row start number from 2 two 8 because my data starts from row number 8

and my final code became as follows:

Please Login or Register  to view this content.

Thank you all,