考題 隨機改變題目與選擇 (12947)

G3:G12{=IFERROR(INDEX(A:A,SMALL(IF((COUNTIF(G$2:G2,A$3:A$12)=0)*(A$3:A$12>0)*MOD(ROW(A1),2),ROW($3:$12),99),RANDBETWEEN(1,6-COUNTIF(G$2:G2,"><"))))&"","")

H3:K12=OFFSET(B$2,-LOOKUP(1,-$G$3:$G3)*2-MOD(ROW(A1),2),)&""