起終號全部不重複 (10238)

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

F2 {=AND(COUNTIF(D:D,ROW(INDIRECT(B$2&":"&B$3)))=1)