單元格多數字 隨機取不重複號碼 (14231)

B3:E12{=IFERROR(TEXT(LARGE(IF(COUNTIF($A3:A3,TRIM(MID(SUBSTITUTE($A3,",",REPT(" ",99)),ROW($1:$9)*99-98,99)))=0,(0&TRIM(MID(SUBSTITUTE($A3,",",REPT(" ",99)),ROW($1:$9)*99-98,99)))*1),RANDBETWEEN(1,LEN($A3)-LEN(SUBSTITUTE($A3,",",))+2-COLUMN(A1))),"0;;"&A3),"")



留言