Matching data based on date field

[didierodayo]

Hi Everyone,

I need your expertise again.

In the attached document when people place orders where ProductCode='40'  they must be another corresponding other with the Same Ordernumber and orderdate BUT diffenrent ProductCode.

Where this is not present I would like to represent the result on a Chart/table showing that there are Orders with ProductCode ='40'
with or with no corresponding/matching OrderDate for the same OrderNumber.

I appreciate any assistance.

Regards
Didier

[#2]

Change the color of the rows and it okay. But it depends on the order of the excel! Hope this helps!