=IF(ROW()<=ROUND(SUM(1/COUNTIF($A$1:$A$13,$A$1:$A$13)),0),INDEX($A$1:$A$13,SMALL(IF(MATCH($A$1:$A$13,$A$1:$A$13,0)=ROW($A$1:$A$13),ROW($A$1:$A$13)),ROW())),"")
用这个函数,具体根据实际修改
j2=IF(ROW()<=ROUND(SUM(1/COUNTIF($A$1:$A$10,$A$1:$A$10)),0),INDEX($A$1:$A$10,SMALL(IF(MATCH($A$1:$A$10,$A$1:$A$10,0)=ROW($A$1:$A$10),ROW($A$1:$A$10)),ROW())),"")
K2=IF(ROW()<=ROUND(SUM(1/COUNTIF($B$1:$B$10,$B$1:$B$10)),0),INDEX($B$1:$B$10,SMALL(IF(MATCH($B$1:$B$10,$B$1:$B$10,0)=ROW($B$1:$B$10),ROW($B$1:$B$10)),ROW())),"")
L2=IF(ROW()<=ROUND(SUM(1/COUNTIF($C$1:$C$10,$C$1:$C$10)),0),INDEX($C$1:$C$10,SMALL(IF(MATCH($C$1:$C$10,$C$1:$C$10,0)=ROW($C$1:$C$10),ROW($C$1:$C$10)),ROW())),"")
M2=IF(ROW()<=ROUND(SUM(1/COUNTIF($D$1:$D$10,$D$1:$D$10)),0),INDEX($D$1:$D$10,SMALL(IF(MATCH($D$1:$D$10,$D$1:$D$10,0)=ROW($D$1:$D$10),ROW($D$1:$D$10)),ROW())),"")
N2=IF(ROW()<=ROUND(SUM(1/COUNTIF($E$1:$E$10,$E$1:$E$10)),0),INDEX($E$1:$E$10,SMALL(IF(MATCH($E$1:$E$10,$E$1:$E$10,0)=ROW($E$1:$E$10),ROW($E$1:$E$10)),ROW())),"")
其他以此类推
数组公式,按CTRL+SHIFT+回车键后,下拉
公式下拉