Unmatching values

Hi all :wave:

Not sure if this has been covered already :sweat_smile:

I am looking for a formula which finds the unmatching values of 2 tables, like

.matches doesn’t work obviously. Finding the matches is easy, but the opposite :thinking:
Many thanks for your support :pray:

Dear @Thomas_Schulz

Quite sure this post should support you in the right direction

Comparing Differences between two lists


The post @Jean_Pierre_Traets pointed to has the solution. For your instance, this would be the formula:


1 Like