D2 下拉 (起 終数設定 0~98){=IFERROR(SMALL(IF((ROW($1:$99)-1>=B$2)*(ROW($1:$99)-1<=B$6)*(COUNTIF(D$1:D1,ROW($1:$99)-1)=0),ROW($1:$99)-1),RANDBETWEEN(1,B$6-B$2+2-ROW(A1))),"")
K2 下拉{=IFERROR(SMALL(IF(COUNTIF(D$1:D1,ROW(INDIRECT(MAX(B$2,1)&":"&B$6+(B$2=0)))-(B$2=0))=0,ROW(INDIRECT(MAX(B$2,1)&":"&B$6+(B$2=0)))-(B$2=0)),RANDBETWEEN(1,B$6-B$2+2-ROW(A1))),"")
F2=SUMPRODUCT(COUNTIF(D2:D99,ROW(INDIRECT(MAX(B$2,1)&":"&B$6+(B$2=0)))-(B$2=0)))=B6-B2+1
M2=SUMPRODUCT(COUNTIF(K2:K99,ROW(INDIRECT(MAX(I$2,1)&":"&I$6+(I$2=0)))-(I$2=0)))=I6-I2+1 |