隨機產生形式 (8986)

C2=RANDBETWEEN(1,COUNTA(B:B)-1)

E2:H5=MID(OFFSET($B$1,$C$2,),ROW(A1)*4-4+COLUMN(A1),1)

C6加=RANDBETWEEN(0,1)

E2:H5改 (形式代碼多一倍形式)=MOD(MID(OFFSET($B$1,$C$2,),ROW(A1)*4-4+COLUMN(A1),1)+$C$6,2)