Create 1 list from 2 tables and removing duplicates

[Ciggy36]

Hello Community,

I've have an issue and I'm assuming I'd need to use the INDEX / SORT / MATCH functions, but I'm a bit perplexed on where to start with this one - This one is beyond my tiny little brain

I have two tables.
Both tables have the same format, and Table1 will 'always' include the data that's in Table2.
Table1 will also have more data than Table2.

So I need to compare the data int the two tables and the data thats in Table1 & not in table 2 be listed in a separate list.

See an example of the data and how ideally it would get displayed.

Any Help greatly appreciated

Lists.xlsx

Thanks
Tony

[AliGW]

Merge the two tables using PowerQuery on the name field - a left-anti join should leave you with just the records unique to the first table.

Your other thread needs marking as solved, please. Thanks!

[Ciggy36]

Thanks for the feedback, I've not used PowerQuery before I'll see if I can figure it out.

How do you mark a thread as resolved? I can't see anywhere on the screen that enables me to mark it as resolved?
Attachment 714347

Thanks
Tony

[Fluff13]

How about
=FILTER(Table1[#All],ISNA(MATCH(Table1[[#All],[Name]],Table2[Name],0)))

This will not work if you try to put it into a table.

[AliGW]

I left instructions in the other thread telling you how to mark a thread as solved.

[Ciggy36]

I left instructions in the other thread telling you how to mark a thread as solved.

All done

[Ciggy36]

How about
=FILTER(Table1[#All],ISNA(MATCH(Table1[[#All],[Name]],Table2[Name],0)))

This will not work if you try to put it into a table.

Thanks - this might work - I'll try playing around with it in my mastersheet