Question

EXCEL统一表格中,如何根据两列同时各自重复,在第三列中标示“两列都重复”否则为空

Answer 1

C1输入：

=IF(AND(COUNTIF(A1:A7,A1)>1,COUNTIF(B1:B7,B1)>1),"AB两列各自同时重复","")

可以在D列和E列判断“原始”和“第几次重复”,在D1和E1输入：

=IF(COUNTIF($A$1:A1,A1)=1,"原始","第"&COUNTIF($A$1:A1,A1)-1&"次重复")

=IF(COUNTIF($B$1:B1,B1)=1,"原始","第"&COUNTIF($B$1:B1,B1)-1&"次重复")