等號後面數字 提起 (13260)

E1=-LOOKUP(1,-MID(SUBSTITUTE(A$1,";"&C1&"=",REPT(" ",99)),99,ROW($1:$99)))

另解=-LOOKUP(1,-MID(A$1,FIND(";"&C1&"=",A$1)+LEN(C1)+2,ROW($1:$9)))