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
Bookmarks