excel 表一 A列中显示的数值 自动按顺序显示到表二A列中,表一中A列重...答:在表二的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...