0
I have a row of 6 alpha-numeric values as in the picture. I need a formula that will determine the three highest numerical values across each row, and then display the letters associated with those values in the correct order (descending). For example, row 1 results in an answer RES, as R is the highest in the row, followed by E, followed by S. Where there is is a match (as in above), the first to appear gets preference. I am a basic user of Excel and this has got me stumped. I can do elements of the solution but it doesnt like it when I try to combine. Grateful for your help.
1What elements do you have? – Forward Ed – 2018-12-05T13:43:34.197
1is it always just 2 digitsat the end? – Forward Ed – 2018-12-05T13:46:33.763
6 elements R, I, A, S, E, C and always just two digits at the end. – Joel – 2018-12-06T15:29:22.770