è§æ ·è¡¨æªå¾
Båæå¤å°å·ç å¨Aåä¸ï¼è·¨è¡¨çå ä¸å·¥ä½è¡¨åå³å¯
=SUMPRODUCT(COUNTIF(A1:A10,B1:B6))
追é®è¿ä¸ªåªæ¯æç¸åçæ°éæ¾ç¤ºåºæ¥ï¼æ¯å¦ææ³æBåå¨Aåä¸æç人åä¿¡æ¯ï¼åç¬ååºæ¥å¯ä»¥å
æ¯å¦äººåä¿¡æ¯æå§åï¼å¹´é¾ï¼èº«ä»½è¯å·çï¼
追çå¯ä»¥æåçï¼è§æ ·è¡¨ï¼æEåå¨Aåçä¿¡æ¯æåå°G:Iå
G1è¾å ¥
=INDEX(A:A,SMALL(IF(COUNTIF($E$1:$E$6,$A$1:$A$100),ROW($1:$100),200),ROW(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼å³æåä¸æå°æ æ°æ®
谢谢ï¼é«æ
没有残疾人号,你哪里复制的答案,两个表格用身份证号做对比