Address of cell containing maximum value

Suppose I have some values in cells A1:D60
I want to find the address of the maximum value, what formula would I need?

I have tried

=CELL("address",INDEX(A1:A100,MATCH(MAX(A1:D60),A1:D60,0)))

but this fails.


It seems to work fine when I use it for =CELL("address",INDEX(A1:A100,MATCH(MAX(A1:A60),A1:A60,0)))

i.e. when all the values are in one row.
Does anyone know how to do this search for multiple rows?

Thanks.

hi, this is array formula
the data in a1:d17 cells
=ADDRESS(MAX((A1:D17=MAX(A1:D17))*(ROW(A1:A17))),MAX((A1:D17=MAX(A1:D17))*COLUMN(A1:D1)),4) CSE

This doesn't work.

And I don't understand where this comes from.
Please clarify your logic in this.

To my understanding

ADDRESS(row_num,column_num)

According to your formula
Row number: MAX((A1:D17=MAX(A1:D17))*(ROW(A1:A17)))
Column number: MAX((A1:D17=MAX(A1:D17))*COLUMN(A1:D1))

How are these row and column numbers?

That is right,
every variable (max functions) determines row and column numbers,
adding the sample file, have a look pls

Ok, just managed it. I've learned something new today about the array functions.

Thank you very much eisayew.