B5:C5{=MID(RIGHT(MAX((MOD(SMALL({6;8;9}*10+{6,8,9},ROW(1:9)),11)>0)*MMULT(N(ISERR(FIND({6,8,9},SMALL({6;8;9}*10+{6,8,9},ROW(1:9))))),{6;8;9})*SMALL({6;8;9}*10+{6,8,9},ROW(1:9))/1%+SMALL({6;8;9}*10+{6,8,9},ROW(1:9))),2),COLUMN(A1),1)
E5=SUM((COUNTIF(B5:C5,{6,8,9})=0)*{6,8,9})
F8=(B8*10+C8)*E8
留言
張貼留言