Troubles with using an array in a formula

[jelmerschellevis]

Hi,

I'd like use a formula that returns the address (or the row+column numbers) of the max value in a range (e.g. AD88:BA118). All the cells in the range contain numbers.

I've tried this formula:
=ADDRESS(MAX((AD88:BA118=N128)*ROW(AD88:BA118));MAX((AD88:BA118=N128)*COLUMN(AD88:BA118));4)

(cell N128 calculates the max value for AD88:BA118).

However it looks like this doesn't work with arrays, since I get the "#VALUE!" output. How can this be solved? Different formula, or changing some settings so the formula will accept arrays?

Thanks,

Jelmer

BTW I'm using Excel 2010.

 

[Firefly2012]

Are you entering the formula with Ctrl+Shift+Enter rather than just enter? If entered correctly, Excel will surround with curly braces in the formula bar {}. It is an array formula.

 

[jelmerschellevis]

I thought I tried that before, anyway tried it now and it works. Issue solved, thanks.