comparing data between spreadsheets

[steambucky]

Hello guys,

Please bare with my lame example I have 2 spreadsheets i am wanting to compare data between them on one feild.  Spreadsheet A should have all the data I need. I have found another spreadsheet (B), and I want to check to see that A actually has all the data from B or work our what the differences are.

Spreadsheet A      

Colum name: PersonName

Data      : Fred

Data       : Betty

Data       : Max

Data      : Chad

Spreadsheet B      

Colum name: PersonName

Data      : Max

Data      : Chad

What are the functions/features I need to learn to do this? (The less scripting the better)  I have created a realationship between the 2 spreadsheets on the same feild. Can you point me in a direction?

Thanks in advance

[v-yulgu-msft · Accepted solution]

Hi @steambucky,

You could create a New Table using EXCEPT function which returns a table that contains the rows of table B which does not exist in Table A. If a row appears at all in both tables, it and its duplicates are not present in the result set. Thus if the table is null ,this is to say that Table A actually has all the data from Table B.

Table=EXCEPT (B, A)

 

Best regards,
Yuliana Gu