本文详细介绍了一种使用Excel进行数据对比的有效方法，通过示例展示了如何利用COUNTIF函数找出两个列表中独有的数据项，适用于需要快速定位不同数据的工作场景。
A B ---------------A有B没有--------- ----------- B有A没有------------
1 1 =IF(COUNTIF(B$2:B$6,A2)=0,A2,"") =IF(COUNTIF(A$2:A$6,B2)=0,B2,"")
3 2 =IF(COUNTIF(B$2:B$6,A3)=0,A3,"") =IF(COUNTIF(A$2:A$6,B3)=0,B3,"")
5 3 =IF(COUNTIF(B$2:B$6,A4)=0,A4,"") =IF(COUNTIF(A$2:A$6,B4)=0,B4,"")
7 4 =IF(COUNTIF(B$2:B$6,A5)=0,A5,"") =IF(COUNTIF(A$2:A$6,B5)=0,B5,"")
9 5 =IF(COUNTIF(B$2:B$6,A6)=0,A6,"") =IF(COUNTIF(A$2:A$6,B6)=0,B6,"")
1 1 =IF(COUNTIF(B$2:B$6,A2)=0,A2,"") =IF(COUNTIF(A$2:A$6,B2)=0,B2,"")
3 2 =IF(COUNTIF(B$2:B$6,A3)=0,A3,"") =IF(COUNTIF(A$2:A$6,B3)=0,B3,"")
5 3 =IF(COUNTIF(B$2:B$6,A4)=0,A4,"") =IF(COUNTIF(A$2:A$6,B4)=0,B4,"")
7 4 =IF(COUNTIF(B$2:B$6,A5)=0,A5,"") =IF(COUNTIF(A$2:A$6,B5)=0,B5,"")
9 5 =IF(COUNTIF(B$2:B$6,A6)=0,A6,"") =IF(COUNTIF(A$2:A$6,B6)=0,B6,"")
扫一扫
2132
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
