202210031508随机不重複取題庫 (10567)

G2下拉 (随机不重複取全部){=INDIRECT(TEXT(SMALL(IF(COUNTIF(G$1:G1,A$2:E$11)=0,ROW($2:$11)/1%+{1,2,3,4,5}),RANDBETWEEN(1,COUNTA(A:E)-ROW(A1))),"!R0C00"),)

I2=AND(MATCH(G2:G11,G2:G11,)=ROW(1:10))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank