Doug Wrote:
I'd like to have the cell address returned along with a value when I use
the
MAX function. Is there a way to do that?

Assuming that your entries are in Cells A1:A100, you can do it this way
...

In Cell B1, the formula *=max(A1:A100)* and

in Cell B2, the cell location of the maximum number in the range (shown
in B1) is given by the formula

=CELL(\"ADDRESS\",INDEX(A1:A100,MATCH(MAX(A1:A100) ,A1:A100
,0)))

BTW, if you do not want to know what the maximum number is, you can
simply go directly to entering the formula in B2.

Regards and hope this will help you.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=400281