隨機 某數 ~ 某數 不重複 (12803)

B2下拉{=IFERROR(SMALL(IF(COUNTIF(B$1:B1,ROW(INDIRECT(E$2&":"&E$3)))=0,ROW(INDIRECT(E$2&":"&E$3))),RANDBETWEEN(1,E$3-E$2+2-ROW(A1))),"")

E6=AND(COUNTIF(B:B,ROW(INDIRECT(E2&":"&E3))))*1



留言