# Compare lists and extract the not matched numbers

**URL:** <https://forum.dynamobim.com/t/compare-lists-and-extract-the-not-matched-numbers/1502>\
**Category:** Packages\
**Created:** [May 19, 2015, 2:13pm UTC](https://forum.dynamobim.com/t/compare-lists-and-extract-the-not-matched-numbers/1502 "2015-05-19T14:13:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jesper\_Wallaert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jesper_wallaert/32/34886_2.png) [@Jesper\_Wallaert](https://forum.dynamobim.com/u/Jesper_Wallaert)\
**Post date:** [May 19, 2015, 2:13pm UTC](https://forum.dynamobim.com/t/compare-lists-and-extract-the-not-matched-numbers/1502/1 "2015-05-19T14:13:40Z")

</div>

Hi all

I have to lists one from Excel and one from Revit.

The list in Excel is not matching the list from Revit which containing the true amount of space numbers to be exact.

My target is to compare the two lists and extract the missing numbers in the excel list.

BR

Jesper

[ 

![list not maching](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/0/0ae87786c76ba4c6067e053aa2c07297d90c3035.png)

 ](http://dynamobim.com/wp-content/uploads/forum-assets/jwagrontmij-dk/05/19/list-not-maching.png)

---

<div class="post-metadata">

**Author:** ![john\_pierson](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/john_pierson/32/191977_2.png) [@john\_pierson](https://forum.dynamobim.com/u/john_pierson)\
**Post date:** [May 19, 2015, 3:28pm UTC](https://forum.dynamobim.com/t/compare-lists-and-extract-the-not-matched-numbers/1502/2 "2015-05-19T15:28:24Z")

</div>

I think this is what you needed ![2015-05-19_14h56_57](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/1X/f6fc2d3fa1cd5bbde9def216fc0d1791ddfa995e.png)

---

<div class="post-metadata">

**Author:** ![Jesper\_Wallaert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jesper_wallaert/32/34886_2.png) [@Jesper\_Wallaert](https://forum.dynamobim.com/u/Jesper_Wallaert)\
**Post date:** [May 20, 2015, 4:06am UTC](https://forum.dynamobim.com/t/compare-lists-and-extract-the-not-matched-numbers/1502/3 "2015-05-20T04:06:42Z")

</div>

Spot on!!

Thx

---

<div class="post-metadata">

**Author:** ![David\_Baldacchino](https://avatars.discourse-cdn.com/v4/letter/d/e8c25b/32.png) [@David\_Baldacchino](https://forum.dynamobim.com/u/David_Baldacchino)\
**Post date:** [May 20, 2015, 11:21am UTC](https://forum.dynamobim.com/t/compare-lists-and-extract-the-not-matched-numbers/1502/4 "2015-05-20T11:21:45Z")

</div>

Or the built-in node SetDifference?

[ 

![SetDifference](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/1/1094f7ef5b7055758bd8781e212537137f0d5474.png)

 ](http://dynamobim.com/wp-content/uploads/forum-assets/dbaldacchino/05/20/SetDifference.png)