G2:G7{=SUM((LEFT(A$2:A$16,LEN(F2))=F2)*B$2:B$16)-SUM((RIGHT(A$2:A$16,LEN(F2))=F2)*B$2:B$16)+N(G1)
C2:C16{=1028-MAX((ROW($2:$7)>=MATCH(LEFT(A2,FIND("-",A2)-1),F:F,))*(ROW($2:$7)<MATCH(MID(A2,FIND("-",A2)+1,9),F:F,))*G$2:G$7)
無輔助C2:C16=MIN(ABS(11028+MMULT(N(ROW($2:$7)>COLUMN(A:F)),SUMIF(A:A,"*"&F$2:F$7,B:B)-SUMIF(A:A,F$2:F$7&"*",B:B)-ISNUMBER(FIND(F$2:F$7,A7))/1%%)))
留言
張貼留言