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" <cestpasbon@çanonplus44.fr> wrote in message
news:OVwl2pqXFHA.3032@TK2MSFTNGP10.phx.gbl...
> 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. Snrub@discussions.microsoft.com> a écrit dans le message
de
> news: 5ECBDE62-5667-4376-9CCA-A8CE9E40F210@microsoft.com...
> >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?
>
>