In the example file attached I have multiple sheets containing 3 lists each. The first 2 lists on each sheet are combined in the 3rd by using a formula devised by one of the clever people on this forum.
If a value is present in the second list but not in the first, I have manually marked it as a "New entry" - ideally this would be automated.
What I want to do next is filter out all the new entries from across all the sheets and combine them in a separate list containing just the unique values.
Can anybody help, please?
Andre
Bookmarks