+ Reply to Thread
Results 1 to 2 of 2

compare two worksheets to find missing or incorrect data

  1. #1
    Registered User
    Join Date
    06-24-2011
    Location
    Chicago, il
    MS-Off Ver
    Excel 2007
    Posts
    14

    compare two worksheets to find missing or incorrect data

    I have two spreadsheets, each spreadsheet will contain a same load id number. What I am looking for is a formula to use on the master spreadsheet to comare on the second spreadsheet for either missing or incorrect data. If the data is on the spreadsheet, I need to compare five fields for accuracy.

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: compare two worksheets to find missing or incorrect data

    Hello and welcome to the forum,

    You can achieve this by using INDEX MATCH in combination with COUNTIF.

    For best results, can you provide a small sample file with dummy data? It will be easier for others to help and give you advice too.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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