假设数据在A1:A20中,D2中输入=INDEX(A$1:A$20,MATCH(,COUNTIF(D$1:D1,A$1:A$20),))&""同时按下CTRL+SHIFT+回车,输入数组公式,下拉。E2中输入=IF(COLUMN(A1)>COUNTIF($A$1:$A$20,$D2),"",INDEX($B$1:$B$20,SMALL(IF(COUNTIF($D2,$A$1:$A$20),ROW($1:$20),4^8),COLUMN(A1))))同时按下CTRL+SHIFT+回车,输入数组公式,右拉,下拉。单元格地址自己修改。... |