怎么样用EXCEL表格将A列和B列数据重新对应排列,以筛选出两组表格不...答:如A列和B列为原始数值,C1输入 =if(countif(B:B,a1)=1,"",if(countif(B:B,a1)>1,"请核对","无此值")D1输入 =if(countif(A:A,b1)=1,"",if(countif(B:B,a1)>1,"请核对","无此值")向下填充公式即可。如C列单元格计算结果为空值,说明A列与B列有相对应的数值,且...
EXCEL判断满足条件的A列所对应的B列数据是否相同,如果都相同则显示为...答:公式为:=IF(COUNTIF(A:A,D2)=COUNTIFS(A:A,D2,B:B,VLOOKUP(D2,A:B,2,)),"是","否")如图所示: