單一地區 複製指定次數 (12309)

C2{=IF(ROW(A1)>E$2*SUM(IFERROR(1/COUNTIF(B:B,B$2:B$99),)),"",INDEX(B:B,SMALL(IF(MATCH(B$2:B$99&"",B$2:B$99&"",)=ROW($1:$98),ROW($2:$99)),ROUND(MOD(ROW(A1)-1,SUM(IFERROR(1/COUNTIF(B:B,B$2:B$99),))),)+1)))