随機提取單元格3位數 依组数 (12629)

D2{=IF(ROW(A1)>F$2,"",MID(B$2,SMALL(IF(COUNTIF(D$1:D1,MID(B$2,ROW($1:$109)*4-3,3))=0,ROW($1:$109)),RANDBETWEEN(1,INT((LEN(B$2)+1)/4)+1-ROW(A1)))*4-3,3))



留言