+ Reply to Thread
Results 1 to 6 of 6

Comparing two workbooks and noting differences.

  1. 12-03-2019, 02:26 PM #1
    ewalton2
    ewalton2 is offline
    Registered User
    Join Date
    12-03-2019
    Location
    Indianapolis, IN
    MS-Off Ver
    Office 2016
    Posts
    3

    Comparing two workbooks and noting differences.

    I have certain columns within a workbook I want to compare to updated data received.
    Workbook info: Patient Name, Medical Record Number, DOB, Age, Lab value
    I am looking for changes of the lab value between the two workbooks. There may also be additions or deletions of patients based on lab value.
    When I use the 'compare spreadsheet' app, if a patient is added in row 2, then the rest of the workbook appears to be different, but it's not. How do I get Excel to compare lab values for patients and also let me know who has been added?
    I have sorted each workbook by lab value from highest to lowest because I am only interested in lab values greater than or equal to 10.
    Thanks!
    Reply With QuoteRegister To Reply
  2. 12-03-2019, 02:38 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Comparing two workbooks and noting differences.

    when I do something similar to this I use this formula to check to see if they exist in the other tab...

    =IFERROR(INDEX('sheet1'!$M$2:$M$8000,MATCH($A3,'sheet1'!$B$2:$B$8000,0)),"not in list")

    that tells me if they are in the other list. With that formula I do not need either sheet to be in any sorted order.

    then the question I have is... you say you are interested in lab values greater than or equal to 10, are you meaning lab value CHANGES greater than or equal to 10 or just any lab value of 10 or more?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 12-03-2019, 02:41 PM #3
    ewalton2
    ewalton2 is offline
    Registered User
    Join Date
    12-03-2019
    Location
    Indianapolis, IN
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Comparing two workbooks and noting differences.

    Yes, I am looking for the lab value CHANGES.
    Reply With QuoteRegister To Reply
  4. 12-04-2019, 11:10 AM #4
    AhsanQatar
    AhsanQatar is offline
    Registered User
    Join Date
    10-22-2019
    Location
    Qatar
    MS-Off Ver
    2013
    Posts
    58

    Re: Comparing two workbooks and noting differences.

    Hi,
    If you can upload sample sheet, it'll make better understanding.
    Reply With QuoteRegister To Reply
  5. 12-05-2019, 01:10 PM #5
    ewalton2
    ewalton2 is offline
    Registered User
    Join Date
    12-03-2019
    Location
    Indianapolis, IN
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Comparing two workbooks and noting differences.

    Here is an example of data I am working with. I want to compare the two sheets, original and new data. I would like the differences highlighted, the new Lab Values for the patients and the new patient that was added.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 12-05-2019, 01:43 PM #6
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Comparing two workbooks and noting differences.

    not knowing what results you want here is my take on your workbook (attached).
    first formula in col F of New Data tab is =IFERROR(INDEX('Original Data'!$A:$A,MATCH(B2,'Original Data'!$B:$B,0)),"not in original data")
    second formula in col G of New Data tab is
    =IF(F2="not in original data",F2,IF(VLOOKUP(B2,'Original Data'!$B$2:$E$6,4,FALSE)>=10,VLOOKUP(B2,'Original Data'!$B$2:$E$6,4,FALSE),"not greater than 10"))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] comparing 2 workbooks, looking for differences in quatities
    By matiiss in forum Excel General
    Replies: 0
    Last Post: 09-16-2016, 03:41 AM
  2. Comparing 2 excel workbooks and highlighting the differences
    By AnkitTibra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2014, 03:24 AM
  3. Comparing Two Excel Workbooks & Output any differences
    By Khurrambilal01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 02:00 PM
  4. [SOLVED] Comparing two sheets for differences
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2013, 06:43 AM
  5. Most Efficient Way in Comparing Two Workbooks and Consolidating Found Differences
    By quixter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 12:46 PM
  6. Comparing differences between two columns
    By MI_Analyst in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 06:51 AM
  7. Comparing two workbooks and highlighting the differences
    By Charles C. in forum Excel General
    Replies: 2
    Last Post: 07-26-2006, 02:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1