见样表截图在sheet3的A列提取sheet1与sheet2A列相同的姓名sheet3的A1输入=INDEX(Sheet1!A:A,SMALL(IF(COUNTIF(Sheet2!A:A,Sheet1!$A$1:$A$100),ROW($1:$100),4^8),ROW(A1)))&""数组公式，先按住CTRL+SHIFT,最后回车公式下拉
90
2024-01-09 05:25
admin