excel使ç¨ä¸ï¼æ两个æ¥æç¸åæ°æ®çå·¥ä½è¡¨ï¼åºè¯¥æä¹çéåºè¿äºæ°æ®å¢?ä¸é¢å°±è·å¦è¯ç½å°ç¼ä¸èµ·æ¥ççå§ã
ããexcelçé两个表ä¸ç¸åæ°æ®çæ¹æ³1
ããå¨âSheet1âæ¾ä¸æ°æ®ä¸ã
ããå¨âSheet2âæ¾ä¸æ°æ®äºã
ããå¨sheet1çB2åå
æ ¼ä¸è¾å
¥â=if(countif())âã
ããå°é¼ æ æ¾å¨â=if(countif())âä¸é´çå°æ¬å·ä¸ï¼ç¹å»sheet2éæ©å
¨é¨æ°æ®ã
ããåå°sheet1çå
¬å¼ï¼è¾å
¥â=IF(COUNTIF(Sheet2!A1:A20,A1),"S","F")âã
ããæå车ï¼æ¾ç¤ºä¸ºSç表示sheet2ä¸çæ°æ®æ¯sheet1ä¸çï¼æ¾ç¤ºä¸ºFçå°±ä¸æ¯ã
ããä»è¿ä¸è¡æä¸å¡«å
ï¼å
¨é¨æ°æ®å°±å¯çéå®æ¯ã
ããexcelçé两个表ä¸ç¸åæ°æ®çæ¹æ³2
ãã1.å°ä¸¤ä¸ªå·¥ä½è¡¨æ¾å¨ä¸ä¸ªçªå£ä¸ï¼å¦å¾æ示ï¼sheet1æ¯å
¨é¨å¦ççï¼sheet2æ¯æçå¦çè±åã
ãã2.å¨sheet1ç¸å¯¹åºåååä¸è¡ç空ç½åºè¾å
¥=if(countif())
ãã3.ç¶ååæ¢å°sheet2ï¼éä¸å
¨é¨åå并å车
ãã4.ååæ¢å°sheet1ï¼è¿æ¶è¿ä¸ªå½æ°åæäº=if(countif(Sheet2!A1:A44))
温馨提示:答案为网友推荐,仅供参考