Find first max value in line then second etc ...

[Berna11]

Good evening, I'm trying to find the sequence of values, starting from the max then the second then the third etc ... and shows the initials of row C5: L5.
the formula I'm using,

Please Login or Register  to view this content.

as you can see in the attached file, gives me wrong values from Q12: O12. should give me: CC LL DD GG AA
Thank you

[Richard Buttrey]

Hi,

One way in Q6 copied throughout the table

Please Login or Register  to view this content.

[Berna11]

Hi,
Perfect Richard works
Thank you