各指定格數區域 隨機不重複顯示 (13977)

F2{=INDEX(B:B,RIGHT(MIN(IF(COUNTIF(F$1:F1,B$2:B$17)=0,INT((ROW($1:$16)-1)/D$2)/1%%+RANDBETWEEN(ROW(2:17)^0,99)/1%+ROW($2:$17))),2))



留言