F2:I5{=IF(COLUMN(A1)>$E2,"",INDEX($B:$B,SMALL(IF(($A$2:$A$21=$D2)*(COUNTIF($E2:E2,$B$2:$B$21)=0),ROW($2:$21)),RANDBETWEEN(1,SUM(N($A$2:$A$21=$D2))-COLUMN(A1)+1))))
K2:K5{=SUM((MATCH(F2:I2,F2:I2,)={1,2,3,4})*(IFERROR(LOOKUP(F2:I2,B$2:B$21,A$2:A$21),)=D2))=E2
格式化 (4组抽中人員) A2:B21=COUNTIF($F$5:$I$5,$B2)
留言
張貼留言