How to Extract Unique Values from same format spreadsheet in two different workbooks

[rsomist]

I am currently working with a workbook that gets weekly updates in a brand new workbook. I am trying to compare the two workbooks and extract the unique values from the new one. I have tried using Spreadsheet Compare, but it only lists what specific lines have been added, not the actual unique data. Best solution for this?

 

[Hui]

You have 2 choices:

SQL:
You can use an SQL query to both merge the data and extract distinct/unique values at the same time

It will be something like

SELECT Distinct ID, FirstName, MiddleName, LastName, Age, DOB From [Table1$]
UNION ALL
SELECT Distinct ID, FirstName, MiddleName, LastName, Age, DOB From [Table2$]

but someone with an SQL Background will be better to give specific advice

Consolidate:
You could also use the Excel Consolidate facility
Refer: https://www.ablebits.com/office-addins-blog/2015/09/01/consolidate-excel-merge-sheets/

 

[AVK]

Try with below formula.
=INDEX(Sheet1!$A$2:$A$20,MATCH(0,COUNTIF($A$1:A1, Sheet1!$A$2:$A$20),0))
Attention : For an array formula
> Press and hold Ctrl+Shift
>Press Enter
>Release all keys

 

[Chihiro]

This sort of operation is best done via MS Query or PowerQuery.

See link for some example.
Simple Left Anti Join (you'll then need to add Distinct operation)
http://chandoo.org/forum/threads/finding-the-differences-between-two-sheets.31436/#post-186999

If you need further help, I'd suggest uploading sample workbook representing your data.