尺碼後數字 分別取出 (10286)


M2:S12{=TEXT(MAX(IFERROR(TRIM(MID(SUBSTITUTE(","&$L2,","&M$1,REPT(" ",99)),99,ROW($1:$99)))*1,)),"0;;")


另解=IFERROR(-LOOKUP(,-MID($L2,FIND(","&M$1,","&$L2)+LEN(M$1),ROW($1:$9))),"")


留言