三項均相同 且算出現次數 顯示 (14372)

D2:D10=IF(OR(MMULT(N(COUNTIFS(A$2:A2,A2,B$2:B2,B2,$C$2:C2,C2)&A2:C2=COUNTIF(OFFSET(E$2:G$2,,,ROW($1:$4)),E$2:G$5)&E$2:G$5),{1;1;1})=3),"提示","")

另解=REPT("提示",COUNTIFS(A$1:A2,A2,B$1:B2,B2,C$1:C2,C2)<=COUNTIFS(E:E,A2,F:F,B2,G:G,C2))