Updated file for results to eliminate duplicates within column D .
Don't know what the desired output of the results should be.
Looking at
this post of almost 2 years ago, I'd say column D isn't actually part of the A:C "table" so probably want what is indicated as Macro Results 2