Excel: Complex tracking of changing dates


Hello Everyone, I have a challenging one, I will try to be precise, but let me know if you need to know anything else. Basically, I have 2 sets of data (as below). I want to have those dates highlighted in DATASET 2 where the date has changed. This is not so easy, because a given item can appear on more than 1 orders and also, certain items will disappear from the orders (as they are available & ship). I am thinking I would need to apply an array formula, as a vlookup will not do. I am sure some of you will have more knowledge on those than me. DATASET 1

Order Product Availability
Order 1 Item A 07/03/2018
Order 1 Item B 07/03/2018
Order 1 Item C 23/02/2018
Order 2 Item D 07/03/2018
Order 2 Item E 14/02/2018
Order 2 Item A 13/03/2018
Order 2 Item C 01/03/2018
Order 3 Item F 07/03/2018
Order 3 Item G 13/02/2018
Order 3 Item A 19/02/2018
Order 3 Item D 16/02/2018
Order 3 Item A 20/02/2018
Order 3 Item H 19/02/2018
DATASET 2
Order Product Availability
Order 1 Item A 10/03/2018
Order 2 Item A 20/03/2018
Order 2 Item C 25/03/2018
Order 3 Item F 07/03/2018
Order 3 Item G 13/02/2018
Order 3 Item A 19/02/2018
Order 3 Item D 10/03/2018
Thanks for any input and helping intention! Tibi


This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of February 27, 2018.


For more resources for Microsoft Excel