cell's address of the largest number

N

novio

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

Niek Otten

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
 
Top