202210021941随机出题10以内加减法 (10564)

B2:B16{=IF(RANDBETWEEN(0,1),REPLACE(RIGHT(LARGE(IF(ROW($1:$9)+COLUMN(A:I)<10,RANDBETWEEN((ROW($1:$9)+COLUMN(A:I))^0,999)/1%+(ROW($1:$9)&COLUMN(A:I))),RANDBETWEEN(1,36)),2),2,,"+"),REPLACE(RIGHT(LARGE(IF(ROW($1:$9)-COLUMN(A:I)>0,RANDBETWEEN((ROW($1:$9)+COLUMN(A:I))^0,999)/1%+(ROW($1:$9)&COLUMN(A:I))),RANDBETWEEN(1,36)),2),2,,"-"))

C2:C16=SUMPRODUCT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B2,"-","+-"),"+",REPT(" ",9)),{1,9},9))*1)

E2=COUNTIFS(C:C,">0",C:C,"<10")

E7=SUMPRODUCT(COUNTIF(B:B,B2:B16))

格式化(重複) B2:B16=COUNTIF(B:B,B2)>1

題庫全部不重複 H2:H73{=INDEX(G:G,SMALL(IF(COUNTIF(H$1:H1,G$2:G$73)=0,ROW($2:$73)),RANDBETWEEN(1,73-ROW(A1))))

J2=SUMPRODUCT(COUNTIF(G:G,H2:H73))

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