隨機分組 依人數與組數 (15402)

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

F2右拉 下拉{=IF(F$1="","",INDEX($B:$B,RIGHT(MAX(($B$2:$B$99>0)*(COUNTIF($F$1:$J1,$B$2:$B$99)=0)*(COUNTIF($E2:E2,$B$2:$B$99)=0)*RANDBETWEEN(ROW(1:98)^0,99)/1%+ROW($2:$99)),2))&"")

L2{=MATCH(,COUNTIF(F:J,B2:B99),)=COUNTA(B:B)