隨機產生 負數起數與正數止數之間 扣除不出現數字 (12827)

 F2 右拉 下拉 {=SMALL(IF(COUNTIF($D:$D,ROW(INDIRECT($B$2-$B$2+1&":"&$B$6-$B$2+1))+$B$2-1)=0,ROW(INDIRECT($B$2-$B$2+1&":"&$B$6-$B$2+1))+$B$2-1),RANDBETWEEN(1,$B$6-$B$2-COUNT($D:$D)+1))

B9=AND(COUNTIF(D:D,F2:J9)=0)