+ Reply to Thread
Results 1 to 4 of 4

How to reconcile two data sets and identify the nulls

  1. #1
    Registered User
    Join Date
    06-11-2019
    Location
    Jarrell, TX
    MS-Off Ver
    Professional Plus 2016
    Posts
    3

    Exclamation How to reconcile two data sets and identify the nulls

    I have two data sets that need to be reconciled. DataSet1 is the source of truth and DataSet2 is what's been entered by the user in our system. DataSet2 should match DataSet1 in a perfect world, but it doesn't. I need to identify the null (0) values for the dates for each person in DataSet2 based off DataSet1. Hope this makes sense. It would be great if I could insert a "1" highlighted red in DataSet2 for the missing values. Please please help!!

    DataSet1:
    Label 3/1 3/2 3/3
    Person1 0 1 1
    Person2 1 1 1
    Person3 0 0 1

    DataSet2:
    Label 3/1 3/2 3/3
    Person1 0 0 1
    Person2 1 0 1
    Person3 0 0 0

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,601

    Re: How to reconcile two data sets and identify the nulls

    Hello kwame84. Welcome to the forum.

    In the attached Conditional formatting is applied to B9:D11.

    In Format Manager a formula defines what applies.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The formatting is Fill > Red and Custom format General "1"
    Dave

  3. #3
    Registered User
    Join Date
    06-11-2019
    Location
    Jarrell, TX
    MS-Off Ver
    Professional Plus 2016
    Posts
    3

    Re: How to reconcile two data sets and identify the nulls

    Thank you Dave! It worked perfectly!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,601

    Re: How to reconcile two data sets and identify the nulls

    Good to hear. You are welcome, and thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Help writing macro to reconcile two data sets and produce a results table
    By iMAQ_23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2018, 02:25 PM
  2. [SOLVED] Need to identify all the data sets based on given key word
    By kiranpat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-06-2014, 02:13 AM
  3. Replies: 1
    Last Post: 03-19-2014, 01:00 PM
  4. (SOLVED) Reconcile two sets of data
    By damilaredavids in forum Excel General
    Replies: 6
    Last Post: 12-31-2011, 05:39 AM
  5. Identify changes between two sets of data
    By swanseaexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2011, 08:31 PM
  6. reconcile 2 data sets with multiple variables
    By Brigitte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2007, 04:53 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