G1
=IF(SUMPRODUCT(COUNTIF(D1:F1,A1:C1)),1,"")
你的公式写成：
=IF(OR(D1=A1,D1=B1,D1=C1,E1=A1,E1=B1,E1=C1,F1=A1,F1=B1,F1=C1),1,"")