+ Reply to Thread
Results 1 to 3 of 3

Compare of 2 tables & find the differences

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Oman
    MS-Off Ver
    Excel 2010
    Posts
    51

    Compare of 2 tables & find the differences

    Dear All

    I need a help. I got employee data from HR system and need to compare with my report.

    The Emp_no should match with the Stat_code

    Need to find how many employees are wrongly mentioned in HR system data and what are the missing employees.

    Enclosed the sample data. How to find out all these conditions.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Compare of 2 tables & find the differences

    You can put this formula in C3:

    =IF(COUNTIFS(G:G,A3,H:H,B3),"OK","missing")

    It should copy down automatically, and will compare individual HR System values with the MIS table. Similarly, you can use this formula in I3:

    =IF(COUNTIFS(A:A,G3,B:B,H3),"OK","missing")

    to compare the other way around.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-16-2014
    Location
    Oman
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: Compare of 2 tables & find the differences

    Thanks. I used VLOOKUP and got it.

+ 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] Macro to Compare 2 Tables and highlight 3 defined differences
    By BG1983 in forum Excel General
    Replies: 16
    Last Post: 02-07-2017, 11:45 AM
  2. How Compare two tables, and result ( only the differences )
    By Chrystopher in forum Excel General
    Replies: 4
    Last Post: 02-20-2015, 10:20 AM
  3. Compare 2 Columns - Find Differences
    By michaeljryan78 in forum Excel General
    Replies: 5
    Last Post: 07-23-2013, 10:43 AM
  4. Compare and find differences between two rows of data
    By Lakeshow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2013, 12:18 PM
  5. Replies: 1
    Last Post: 07-12-2012, 05:43 AM
  6. Compare tables and mark differences (vlookup?)
    By goodhope in forum Excel General
    Replies: 6
    Last Post: 03-25-2011, 04:55 PM
  7. [SOLVED] Compare two spreadsheets to find differences.
    By Toby in forum Excel General
    Replies: 2
    Last Post: 03-28-2005, 09:06 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