|
在表二的A1单元格输入下面公式=IFERROR(INDEX(SMALL(Sheet1!$A$1:$A$100,ROW(Sheet1!$A$1:$A$100)),SMALL(IF(IFERROR(MATCH(SMALL(Sheet1!$A$1:$A$100,ROW($1:$100)),SMALL(Sheet1!$A$1:$A$100,ROW($1:$100)),0)=ROW($1:$100),FALSE),ROW($1:$100),4^8),ROW(1:1))),"")按Ctrl+Shift+Enter再向下拖动复制... |
