现有A,B两列. 想知道和A列相比,B列多出了哪些值,少了那些值
參考答案: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,"")