Share via

How can I merge two different sheets but avoid any duplicates within the new merged sheet?

Anonymous
2022-08-12T19:44:01+00:00

I have an excel document that has two sheets. I want two essentially merge the data from the two sheets and paste this data onto a new sheet but not allow any duplicates to exist in the new list. How can I go about this either through vba or a function.

Below is a small sample of what the data in my excel document would look like. In reality, there are over 13k items in each sheet.

https://www.dropbox.com/scl/fi/ajxme2nsba7x0ownil9wf/Book1.xlsx?dl=0&rlkey=892mb776s7elfq9935ullvian

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2022-08-12T20:37:02+00:00

    Hi Ahiezer

    The best and most dynamic way to do it is with Power Query

    Here is the link to the file with the answer to your question

    https://we.tl/t-nT2uBHqTLY

    The video below will help you to understand the solution

    https://youtu.be/HcfKOusOJhA

    I hope this helps you and gives a solution to your problem

    Do let me know if you need more help

    Regards

    Jeovany

    0 comments