Excel提取两列重复/不同数据

Categories: Development Notes; Tagged with: Excel; @ February 27th, 2011 14:30

需求: 找出两列中重复的数据, 以及差异的数据.
细节: AB两列, 找出A有B无, AB均有, A无B有数据, 分列CDE中.

A有B无: IF(COUNTIF($B:$B,A2)=0,A2,"B列中已有")
AB均有:IF(COUNTIF($B:$B,A2)>0,"AB有重复","B中无匹配")
A无B有: IF(COUNTIF($A:$A,B2)=0,B2,"A中有重复")