每欄不重數值 依起止數 (14179)

E2{=IFERROR(LARGE(IF(COUNTIF(E$1:E1,ROW(INDIRECT($B$2/1%&":"&$C$2/1%))%)=0,ROW(INDIRECT($B$2/1%&":"&$C$2/1%))),RANDBETWEEN(1,ROUND(($C$2-$B$2)/1%+2-ROW(A1),)))%,"")