字母後面3位數找最大 (13303)

E2{=D2&MAX((LEFT(B$2:B$99)=D2)*(0&MID(B$2:B$99,2,9)))

R2{=J2&TEXT(MAX((LEFT(H$2:H$99)=J2)*(0&MID(H$2:H$99,2,9))),"000")