隨機分組數 (14592)

C2:C21=RAND()

F1 右拉=IF(COLUMN(A1)>$D2,"","第 "&COLUMN(A1)&" 組")

F2右拉 下拉{=IF(F$1="","",IFERROR(INDEX($B:$B,RIGHT(SMALL(ROUNDUP(RANK($C$2:$C$21,$C:$C)/$D$2,)/1%+ROW($2:$21),(ROW(A1)-1)*$D$2+COLUMN(A1)),2)),""))