Check for at least one identical value in different column ranges based on ID

This works for your example so perhaps you can generalise it. The formula in D2 is

=IF(A2=A1,"",MAX(IF($A$2:$A$10=A2,COUNTIF($B$2:$B$10,$C$2:$C$10))))

and is an array formula so must be confirmed with CTRL, SHIFT and ENTER.