Hi
I would also recommend to Mr Snrub the MAX function because of Aladin's
judicious remark.

Cordially
Pascal

"Ragdyer" a écrit dans le message de news:
...
Just another way:

=ADDRESS(MAX((B3:Z51=MAX(B3:Z51))*ROW(B3:Z51)),MAX ((B3:Z51=MAX(B3:Z51))*COLU
MN(B3:Z51)))
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"papou" wrote in message
...
Hello
Try this array formula (validate with Ctrl + Shift + Enter):

=ADDRESS(MIN(IF(B3:Z51=LARGE(B3:Z51,1),ROW(B3:Z51) )),MIN(IF(B3:Z51=LARGE(B3:
Z51,1),COLUMN(B3:Z51))))

HTH
Cordially
Pascal

"Mr. Snrub" <Mr. a écrit dans le message
de
news: ...
I have a table of integers ranging from cells B3 to Z51, and I want to
find
the cell address of the largest value.

=LARGE(B3:Z51, 1) will give me the largest value, but how do I find the
cell
address where that largest value is located?