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" wrote in message
...
how do i receive the address of the cell of the largest number on a list ?
That is, A1 / B12 / C32 etc.