201903111457(EXCEL)兩行資料欄比對 找出不存在的數值

A欄和C欄資料比對,找出不存在的資料顯示在B欄

=IF(ISERROR(MATCH(A2,$C$2:$C$4,0)),"not existed","")

A(比對的資料) B(結果) C(被比對的資料)
a a
b b
c c
d not existed
e not existed
f not existed
g not existed
h not existed
a
b
c
d not existed
e not existed
f not existed
g not existed
h not existed

回應





Powered by Xuite
BloggerAds
Google Analytics
累積 | 今日
loading......
平均分數:0 顆星
投票人數:0
我要評分:
ClustrMaps
Locations of visitors to this page