Remove duplicates based on other column.

[domcindor]

Hello, I dont know if I phrased my question right so I will give you a mockup of what I want to achieve.

HOW IT IS NOW:
Attachment 637047


WHAT I WANT:
Attachment 637048

What I have is a lot of data, and what I want to do is if data already exists in group one, delete data from group two.

Remove duplicates seems to remove all duplicates and what I left is 1 ROW.

Any help would be great, thank you so much!

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[domcindor]

Hello,
Thank you so much for welcoming me personally and for quick reply.

I am attaching example woorkbook below.

[mohadin]

Simply

Please Login or Register  to view this content.

[domcindor]

Thank you so much for your solution, it worked flawlessly!
Have a nice day