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
<colgroup><col><col><col></colgroup><tbody>
</tbody>
DATASET 2
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks for any input and helping intention!
Tibi
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 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thanks for any input and helping intention!
Tibi