如图,如果E1-F1其中一个有和A1-C1中相同,那么显示重复,否则显示不重复
H2=IF(SUM(COUNTIF(E2:G2,A2:C2)),"有","无")
用了一个match函数,匹配3个单元格是否有相等的,如果有就输出有重复。(位置不相同也可以)
=IF(COUNT(MATCH(TRANSPOSE(A2:C2),TRANSPOSE(E2:G2),0))>0,"有重复","无重复")
输入按ctrl+shift+enter
要求位置一致如下
=IF(SUM(1*(A2:C2=E2:G2))>0,"有重复","无重复")