Address of Maximum value in Cell

[Session101]

I have a sheet where I enter in numeric values around a range of cells
(B13). I want to be able to acquire the cell address of the max
value.

For example:
Max Value Cell Address
Test A 90 100 180 180 D1
Test B 50 110 101 110 C2
Test C 75 35 14 75 B3

I need a formula to acquire the cell address. I have been trying to use
the address function in this scenario with no luck.

 

[Peo Sjoblom]

One way

=CELL("address",INDEX(B11,MATCH(MAX(B11),B11,0)))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com