Borut
12-08-2020, 11:14 AM
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?
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?