Find a duplicate, match and equal to different columns

Hello guys,

Check the workbook example.

The problem is the following
I need to find a duplicate in a column C, then check which if any of the duplicates have value in column B.
If there is Value in column B, then D is equal to A

In given example the first three rows in column D will be filled with code 3. The next two rows will be empty.