ups it was R i c

=INDIRECT("A"&MATCH(MAX(R1:R29),R1:R29,0))



"excelent" skrev:

=INDIRECT("A"&MATCH(MAX(P1:P29),P1:P29,0))


"Jshendel" skrev:

Hello.
I would like to find a maximum value across a row of 24 and return the title
I have given that column.
So, if the max value of row R is in cell R20, I would like the function to
return the name in cell A20.
Thanks,
Josh