cell's address of the largest number

how do i receive the address of the cell of the largest number on a list ?
That is, A1 / B12 / C32 etc.

Depends on what you mean with "address". Do you want text, like "A1"? Or do
you want a relative position in a table?

In the latter case, consider

=MATCH(MAX(A1:A100),A1:A100,0)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"novio" <novio@discussions.microsoft.com> wrote in message
news:724B8548-DBB6-47F1-808C-49EF1DEC27EB@microsoft.com...
> how do i receive the address of the cell of the largest number on a list ?
> That is, A1 / B12 / C32 etc.