=IF(SUM(IF(MATCH(A1:C1,A1:C1,)=COLUMN(A1:C1),1,0))"),"重复","")可以变换引用方式和引用范围对该公式进行调整
=IF(OR(COUNTIF(A1:G1,A1:G1)>1),"","是")&"否" 试试
