I think this will do what you need:

=IF(COUNTIFS($D$2:$D$10;D2;H$2:H$10;H2;I$2:I$10;I2 )>COUNTIFS(D$2:$D$10;D2;C$2:C$10;C2;H$2:H$10;H2;I$ 2:I$10;I2);"Yes";"")
but you will get an Yes for duplicate entries too... Anyway, I guess in the real table there will be no duplicates (or you will use data instruments-remove duplicates). If there will be duplicate entries, then we need to extend the formula...