Unmatching values

[Thomas_Schulz]

Hi all

Not sure if this has been covered already

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
Many thanks for your support

[Jean_Pierre_Traets]

Dear @Thomas_Schulz

Quite sure this post should support you in the right direction

Comparing Differences between two lists

[BenLee]

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

List.Filter(CurrentValue.Contains(Words).Not())