取最大 依出現等级 (9535)

B2{=-MIN(IFERROR(-VLOOKUP(T(IF({1},"*"&TRIM(MID(SUBSTITUTE(A2,"，",REPT(" ",99)),COLUMN(A:I)*99-98,99))&"*")),D:E,2,),))

另解{=MAX(IFERROR(MATCH("*"&TRIM(MID(SUBSTITUTE(A2,"，",REPT(" ",99)),99*COLUMN(A:I)-98,99))&"*",D:D,),))-1

另解{=MAX((IFERROR(FIND(TRIM(MID(SUBSTITUTE(D$2:D$5,"，",REPT(" ",99)),COLUMN(A:I)*99-98,99)),"@"&A2),)>1)*E$2:E$5)