B2:P15{=IFERROR(IF((COLUMN(A1)>$R$3)+((ROW(A1)-1)*$R$3+COLUMN(A1)>$R$11-$R$7+1),"",SMALL(IF((COUNTIF($B$1:$P1,ROW(INDIRECT($R$7&":"&$R$11)))=0)*(COUNTIF($A2:A2,ROW(INDIRECT($R$7&":"&$R$11)))=0),ROW(INDIRECT($R$7&":"&$R$11))),RANDBETWEEN(1,$R$11-$R$7+2-(ROW(A1)-1)*$R$3-COLUMN(A1)))),"")
留言
張貼留言