G2 下拉 {=IF(ROW()>(MAX(COUNTIF(E:E,E$2:E$99))+2)*COUNT(0/(MATCH(E$2:E$99,E$2:E$99,)=ROW($1:$98))),"",IF(MOD(ROW(),MAX(COUNTIF(E:E,E$2:E$99))+2)=1,G$1,IF(MOD(ROW(),MAX(COUNTIF(E:E,E$2:E$99))+2),INDEX(E:E,SMALL(IF(MATCH(E$2:E$99&"",E$2:E$99&"",)=ROW($1:$98),ROW($2:$99)),INT(ROW()/(MAX(COUNTIF(E:E,$E$2:$E$99))+2))+1)),"")))
H2 右拉 下拉 {=IFERROR(IF($G2="","",IF($G2=$G$1,H$1,INDEX(A:A,SMALL(IF($E$2:$E$99=$G2,ROW($2:$99)),COUNTIF($G$2:$G2,$G2))))),"")
重複多次 設輔助=MAX(COUNTIF(E:E,E$2:E$99))+2
有輔助 G2 下拉 {=IF(ROW()>M$2*COUNT(0/(MATCH(E$2:E$99,E$2:E$99,)=ROW($1:$98))),"",IF(MOD(ROW(),M$2)=1,G$1,IF(MOD(ROW(),M$2),INDEX(E:E,SMALL(IF(MATCH(E$2:E$99&"",E$2:E$99&"",)=ROW($1:$98),ROW($2:$99)),INT(ROW()/M$2)+1)),"")))
留言
張貼留言