Comparing tables in different files

[Ric F]

Hello all!
I'm trying to compare two tables - one from last month (table A) and one from this month (table B). I want to see the differences in this months (table B) file from last. Both tables are identical in columns (A:T). What formula do I use to compare these and find the newly added records?

Ric

 

[Ric F]

ok - I'll try the filter formula again - Thanks for all of your help!

 

[Fluff]

The filter formula would be
=FILTER(A2:AT49944,(ISNA(MATCH(A2:A49944,AA2:AA49944,0)))*(A2:A49944<>""))

 

[Ric F]

Thanks for the updated filter formula. I'll give it a whirl now.

 

[Ric F]

that formula worked perfectly! Thank you Fluff!

 

[Fluff]