Hi folks,

I have two lists containing similiar data. List 1 is essentially the outdated version of list 2. Each list item contains three pieces of information (i.e. 3 data columns).

I'm trying to find a way to compare the two lists and isolate all the items on list 2 that is NOT on list 1 (a new item);

and

isolate the items on list 1 that are not on list 2 (out dated items).

I need to compare all three pieces of data for each line item. For example:

row 1 contains this data in three columns: Product Line > Product Sku > Account

The only unique identifier is the product sku, this will not be repeated on any other line item in the list.

I can post a sample spreadsheet too if needed, lol.

Any suggestions?

~Len