ç»ä½ ä¸¤ä¸ªå ¬å¼ï¼
B2=LOOKUP(COUNT(0/FIND(D$2:D$3,A2))+1,{1,2},{"æ ","æ"})
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
C2=IF(COUNT(0/FIND(D$2:D$3,A2)),"æ","æ ")
åæ ·æ°ç»å ¬å¼ã
èªå·±éä¸ä¸ªå§
å¦æAåçæ°æ®å¯è½å å«Dåæååºçåºåä¸è¶ è¿ä¸ä¸ªï¼å¦Dåæ¢æåºåï¼åæè¡éï¼æ¶ï¼å°±ä¸è½ç¨åé¢çå ¬å¼ãåªå¯è½ä¸ä¸ªçè¯ï¼æ¨èåä¸ä¸ªå ¬å¼ï¼è¿è¡æçç¨é«äºåä¸ä¸ªå ¬å¼ã
修改问题了请看看哦