+ Reply to Thread
Results 1 to 2 of 2

Duplicates between two workbooks

  1. #1
    Registered User
    Join Date
    08-02-2021
    Location
    Texas
    MS-Off Ver
    2019
    Posts
    1

    Duplicates between two workbooks

    I have a weekly report that I have to run covering multiple machines in our environment. Once I've run it I have to update a risk register with the changes. I'm looking for a way to compare the two sheets and delete the duplicates that appear on the previous weeks sheet based off of two specific columns of data. In this case it is column B (Plugin ID) and column C (PC name). I'm wanting to delete the duplicate rows from my current sheet only if they match exactly column B & C exactly from the previous weeks sheet so that it only leaves me with the changes between weeks.

    I've gone trough conditional formatting and I can get it to match on Column B & C so it will highlight duplicates from either column but not B&C together.
    Example:
    Week 1
    Plugin ID A Machine name A
    Plugin ID A Machine Name B
    Plugin ID A Machine Name E

    Week 2
    Plugin ID A Machine Name A
    Plugin ID A Machine Name B
    Plugin ID A Machine Name E
    Plugin ID A Machine Name X

    I want to remove all duplicates so that week 2 only shows:
    Plugin ID A Machine Name X

    After being compared to week 1.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,858

    Re: Duplicates between two workbooks

    This can be accomplished quickly using Power Query/Get and Transform found on the Data Tab. Load both tables/ranges to the PQ Editor. Then Merge the tables using and Anti-Join to show only those items in the second table that is not in the first.

    Here is a link to a tutorial

    https://www.youtube.com/watch?v=9dG63ifH7Pk
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find Duplicates in TWO different workbooks
    By jrtulare185 in forum Excel General
    Replies: 7
    Last Post: 10-08-2020, 12:42 AM
  2. Checking for duplicates between 2 workbooks
    By thanny88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2018, 03:12 PM
  3. Compare 2 different workbooks and delete duplicates
    By Lou54 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2012, 03:45 PM
  4. Sort, duplicates, and new workbooks
    By NeedExcelHelpPlease in forum Excel General
    Replies: 0
    Last Post: 08-13-2012, 11:00 PM
  5. Macro help for duplicates on two workbooks
    By vanthaman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2011, 03:40 AM
  6. Find duplicates over 60 workbooks
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-07-2008, 09:50 PM
  7. Find duplicates over 60 workbooks
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2008, 09:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1