found max number

[Borut]

I have abbreviations in range E9:Ai9. this are diferent, like BO, LD, IO... and K1, K2, K3.

I not found working formula (not vba) that found max number only for K1, K2...
Formula =right(max(E9:AI9);1) only give me max, if I put number to this Range.
but I need it from K1, K2, K3…

solution?

[Borut]

Found.... and change it for me

IF(NUMBERVALUE(RIGHT(A2,2))=MAX(IF(LEFT($A$2:$A$1011)=LEFT(A2,11),NUMBERVAL UE(RIGHT($A$2:$A$10,2)))),TRUE)