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 
Dear @Thomas_Schulz
Quite sure this post should support you in the right direction
4 Likes
The post @Jean_Pierre_Traets pointed to has the solution. For your instance, this would be the formula:
List.Filter(CurrentValue.Contains(Words).Not())
1 Like