Delete row by if data same on column B & E

[oeyandyprawira]

Hi, Please kindly help , is there a macro to do this

Row 3&4 , 9&10 have same data on column B&E, the second row that have same data will be deleted

before.JPG

It will be like below,thx
After.JPG

[Trebor76]

Hi oeyandyprawira,

Try this (though initially on a copy of your data as the results cannot be undone if they're not as expected):

Please Login or Register  to view this content.

Regards,

Robert

[oeyandyprawira]

Hi Trebor,

thx it work but when I tried to other excel file i attached tes delete duplicatev2.xlsx, it's not working there. I confused, please help to test on that file, thx

[Trebor76]

No file attached

Are you checking the same columns i.e. B and E in the active sheet?

[oeyandyprawira]

No file attached

Are you checking the same columns i.e. B and E in the active sheet?

Sorry I don't know how to attach when replying , so I attached in my first post, can you find it?. , yes same checking on same B & E column.

[Trebor76]

There was a space at the end of every second card entry in column B hence every row was unique and so no rows were being deleted.

This should do the job:

Please Login or Register  to view this content.

I'm guessing the card details are fictitious card numbers as you wouldn't want real ones on a public forum.

Regards,

Robert

[oeyandyprawira]

yes Trebor76, thx for your help

[Trebor76]

You're welcome

Thanks for marking the thread as solved and for the rep