# Unmatching values

**URL:** <https://connect.superhuman.com/t/unmatching-values/15889>\
**Category:** Ask the Community\
**Created:** [May 12, 2020, 4:51pm UTC](https://connect.superhuman.com/t/unmatching-values/15889 "2020-05-12T16:51:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\
**Post date:** [May 12, 2020, 4:51pm UTC](https://connect.superhuman.com/t/unmatching-values/15889/1 "2020-05-12T16:51:25Z")

</div>

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

 ![Bildschirmfoto 2020-05-12 um 18.47.32](https://global.discourse-cdn.com/coda1/original/2X/8/8d40f230b18489ecc508fa21f4b56a2d1d0b4643.png)

.matches doesn’t work obviously. Finding the matches is easy, but the opposite 🤔  
Many thanks for your support 🙏

---

<div class="post-metadata">

**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\
**Post date:** [May 12, 2020, 8:22pm UTC](https://connect.superhuman.com/t/unmatching-values/15889/2 "2020-05-12T20:22:48Z")

</div>

Dear @Thomas_Schulz

Quite sure this post should support you in the right direction

[Comparing Differences between two lists](https://connect.superhuman.com/t/comparing-differences-between-two-lists/12706/2)

---

<div class="post-metadata">

**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\
**Post date:** [May 12, 2020, 9:08pm UTC](https://connect.superhuman.com/t/unmatching-values/15889/3 "2020-05-12T21:08:43Z")

</div>

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

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