Address of Maximum value in Cell

[Session101]

I have a sheet where I enter in numeric values around a range of cells (B1:D3). 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(B1:D1,MATCH(MAX(B1:D1),B1:D1,0)))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Session101" <[email protected]> wrote
in message news:[email protected]...
>
> I have a sheet where I enter in numeric values around a range of cells
> (B1:D3). 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.
>
>
> --
> Session101
> ------------------------------------------------------------------------
> Session101's Profile:
> http://www.excelforum.com/member.php...o&userid=14054
> View this thread: http://www.excelforum.com/showthread...hreadid=532415
>