B2下拉{=IFERROR(SMALL(IF((COUNTIF(E:E,ROW(INDIRECT("1:"&D$2)))=0)*(COUNTIF(B$1:B1,ROW(INDIRECT("1:"&D$2)))=0),ROW(INDIRECT("1:"&D$2))),RANDBETWEEN(1,D$2-COUNT($E:$E)-ROW(A1)+1)),"")
G2下拉{=IFERROR(SMALL(IF(COUNTIF(E:E,ROW(INDIRECT("1:"&D$2)))=0,ROW(INDIRECT("1:"&D$2))),ROW(A1)),"")
留言
張貼留言