G3:J9=IFERROR(LOOKUP(1,0/ISERR(-(0&RIGHT(MID(SUBSTITUTE(SUBSTITUTE($B3,"-",),",",REPT(" ",99)),COLUMN(A1)*99-98,ROW($1:$99))))),TRIM(MID(SUBSTITUTE(SUBSTITUTE($B3,"-",),",",REPT(" ",99)),COLUMN(A1)*99-98,ROW($1:$99)))),"")
D3:D7{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(D$2:D2,G$3:J$9)=0)*(G$3:J$9<>""),ROW($3:$9)/1%+COLUMN(G:J))),"!R0C00"),),"")
E3:E7{=IF(D3="","",SUM(ABS(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(B$3:B$9,D3,),",",REPT(" ",99)),COLUMN(A:I)*99-98,99))*1,))))
留言
張貼留言