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
留言
張貼留言