E3:E11{=SUBSTITUTE(LEFT(B3,MIN(FIND(ROW($1:$9),B3&1/17))-1),"+",)
F3:H11=-LOOKUP(1,-MID(SUBSTITUTE(SUBSTITUTE($B3,"=","*"),"*",REPT(" ",99)),MID(IF(1-ISERR(FIND("+",$B3)),213,123),COLUMN(A1),1)*99-ROW($1:$99),ROW($1:$99)))
I3:I11=-LOOKUP(1,-RIGHT(B3,ROW($1:$9)))
留言
張貼留言