隨機出現 依指定次數 (15266)

E2{=OFFSET(B$1,SMALL(IF(C$2:C$5>=COLUMN(A:Z),ROW($1:$4),99),ROW(A1)),)&""

G2:G20區域數組公式{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(C2:C5>=COLUMN(A:I),ROW(2:5)+RANDBETWEEN(COLUMN(A:I)^0,99)/1%),ROW(1:19)),2)),"")