做个样表
假定三列全部重复为"重复"
D列为本表重复标记"CF",E列为异表重复标记'CF"
sheet1的D2输入
=IF(COUNTIFS(A$2:A2,A2,B$击威判们线土婷扬形述2:B2,B2,C$2:C2,C2)>1,"CF","")
E2输入
=IF(COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,B2,Sheet2!C:C,C2)>0,"CF","")
两公式分别下拉
同理,sheet2的d2输入
=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)>1,"CF","")
E2输入
=IF(COUNTIFS(Sheet1!A:A,A2,Sheet1!B:B,B2,Sheet1!C:C,C2)>0,"CF","")
两公式分别下拉
![](https://ask-fd.zol-img.com.cn/g7/M00/08/0D/ChMkK2WjSf2IUan3AADdZDaLB5IAAZkYAEJ6J4AAN18530.jpg)