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
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
The post @Jean_Pierre_Traets pointed to has the solution. For your instance, this would be the formula:
List.Filter(CurrentValue.Contains(Words).Not())