+ Reply to Thread
Results 1 to 2 of 2

Comparing Data from two workbooks

  1. #1
    Registered User
    Join Date
    11-07-2023
    Location
    Connecticut, USA
    MS-Off Ver
    Microsoft 365 and Office
    Posts
    43

    Comparing Data from two workbooks

    Hello,

    I have a workbook with sheet1 where you can see 3 columns, I need these columns to be compare against Workbook2 sheet 2 which also have the same 3 columns that way I will only have the information I really need in sheet2 from sheet 1. For example:

    Sheet 1
    Group LZ has position 3 and 6 and order # between 001 to 014
    1.JPG

    Sheet 2
    Group LZ as you can see in the highlight have position 1 and 2 (which are not in sheet 1) and the order # of course are also not in sheet 1
    2.JPG

    I will like a way for those results that are not in sheet 1 to be highlight in sheet 2 so that way I can deleted them.

    I have 10,000 records for different group position and order that needs to be compare against sheet 1.

    Thank you.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Comparing Data from two workbooks

    Use a formula like

    =IF(ISERROR(MATCH(A2&B2&C2,Sheet1!$A$2:$A$1000&Sheet1!$B$2:$B$1000&Sheet1!$C$2:$C$1000,FALSE)),"Delete","Keep")

    and copy down to match your data on sheet2
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Comparing Data from two different workbooks
    By Aralei in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 04:20 AM
  2. [SOLVED] Comparing data on 2 workbooks
    By Joshua in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Comparing data on 2 workbooks
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  4. Comparing data on 2 workbooks
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. Comparing data on 2 workbooks
    By Joshua in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Comparing data on 2 workbooks
    By Joshua in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Comparing data on 2 workbooks
    By Joshua in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. Comparing data on 2 workbooks
    By Joshua in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2005, 11:05 AM

Tags for this Thread

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