This is one way to return the first max value in the range:

=ADDRESS(8,9+MATCH(MAX(J8:T8),J8:T8,0))



In article ,
Michael Link <Michael wrote:

I have a range ( J8:T8) which contain various values. I am using MAX(J8:T8)
to return the largest number in that range. I also need to know what the cell
address is of that value. Is there a formula I can write that will return the
address of the cell in the range with the highest value?

Thanks!