excel 判断多个单元格内容是否相同，相同返回“相同”

Question

如题所述

Answer 1

E1=IF(SUMPRODUCT(COUNTIF(A1:D1,A1:D1))=COUNTA(A1:D1)^2,"相同","不同")向下复制

Answer 2

=if(and(A1=B1,B1=C1）,"相同","不同")