利用COUNTIF函数找出两列数据间的差异表一：表二：A列A列中有，B列中没有A列与B列都有B列B列中有，A列中没有00142954√00225929√00257377√00137210√00054689√00270608√00147810√00087687√00278724√0013866000156197√0028396300078650√0017613700262275√00077336√00164349√00048223√00210598√00295620√00082375√00249501√00021205√00206705√00288268√00160630√00002953√00061856√00138660√00021742√00283963√00103550√00071357√00251977√00070162√00248803√00100907√00268295√00109453√00185378√00005886√00029142√00036787√00150248√00013102√00167820√00179777√00179767√00005374√00265421√00027185√00091874√00198855√00219998√00288228√00293457√00291517√0005468900119031√0014781000135966√0027872400071311√0015619700007934√0007865000276747√00123190√00242594√00139421√00201877√00265614√00081396√00140043√00238503√0016434900100776√0021059800157374√00215152√00103732√00061660√00225761√00233618√00123664√00013524√00253516√00151735√00085020√00224246√00060168√00040709√00039685√00054128√00284703√00240964√00176137√00272245√00006394√00046632√00203462√00079911√00045813√00171678√00213537√00049314√00275599√00067548√00275516√00277635√00132746√00177258√00230028√00200740√00245258√00153012√00146230√00290598√00247053√00172618√00090163√00039792√00045548√00070674√00066771√00202495√00113827√00098910√00228292√00079660√00200910√00275810√00292464√00215912√00036167√00172651√00189565√00266783√00021143√00235159√00003583√00127407√00063761√00172276√00255189√00255066√00293817√00294308√00287019√00023553√00201152√00214321√00222831√00181666√00230276√00009190√00108304√00291047√00162001√00271981√00000774√00273510√00287226√00170965√00072616√00085097√00130613√00150244√00297173√00037595√00055878√00150118√00143517√00298107√00248975√00263848√00244816√00107615√00222222√00003783√00127842√00185198√00011340√00010971√00158075√00036680√00077499√00245471√00193005√00241419√00095090√00246835√00186713√00292484√00179763√00278245√00298270√00083760√00154076√00277182√00193791√00156335√00152727√00007558√00155835√00180763√00105634√00251343√00024562√00253151√00207596√00145844√00184754√00206442√00019964√00117617√00119030