隨機產生範圍外數字 1~99 (11127)

A1:E10{=SMALL(IF((ROW($1:$99)<$G$2)+(ROW($1:$99)>$G$6),ROW($1:$99)),RANDBETWEEN(1,98-$G$6+$G$2))

G10=COUNTIFS(A:E,">="&G2,A:E,"<="&G6)