比數 找出勝方隊名 (15122)

D2=TEXT(SUM(TEXT({1,-1}%,SUBSTITUTE(C2,"-",";"))*{1,-1}),"!"&LEFT(B2,FIND("-",B2)-1)&";!"&MID(B2,FIND("-",B2)+1,9)&";平手")

另解=TEXT(SUM(MID(SUBSTITUTE(C2,"-",REPT(" ",9)),{1,9},9)*{1,-1}),"!"&LEFT(B2,FIND("-",B2)-1)&";!"&MID(B2,FIND("-",B2)+1,9)&";平手")



留言