请教个随机抓阄公式，可以手工修改，每个人随机抽取的个数

hcm19522

H3:H9 右拉 {=IF(ROW(A1)>H$1,"",INDEX($C:$C,SMALL(IF((COUNTIF($G$3:G$9,$C$2:$C$999)=0)*(COUNTIF(H$2:H2,$C$2:$C$999)=0)*($C$2:$C$999<>""),ROW($2:$999)),RANDBETWEEN(1,COUNTA($C:$C)-ROW(A1)-SUM($G$1:G$1)))))

H13:H20 右拉 {=IF(ROW(A1)>$E$13,"",INDEX($C:$C,SMALL(IF((COUNTIF($G$13:G19,$C$2:$C$999)=0)*(COUNTIF(H$12:H12,$C$2:$C$999)=0)*($C$2:$C$999<>""),ROW($2:$999)),RANDBETWEEN(1,COUNTA($C:$C)-ROW(A1)-(COLUMN(A1)-1)*$E$13))))

N3{=SUM(COUNTIF(H3:L9,H3:L9)*(H3:L9<>""))=SUM(H1:L1)

N13{=SUM(COUNTIF(H13:L20,H13:L20)*(H13:L20<>""))=E13*5

paysjksf

感谢各位   成功了