address of cell with maximum

[meggus]

Hi

I´m looking for the address of a cell in a range where the value i
max.
I tried this formula, but it isn´t working (#NAME?)
=CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0))) from this site:
http://www.exceltip.com/st/Emailed_Tip/615.html

thank

 

[mangesh_yadav]

It works perfectly.

- Manges

 

[meggus]

ah, it´s a problem with the english and german expressions..

 

[mangesh_yadav]

problem with a comma and a semi-colon, i guess.

- Manges

 

[meggus]

yes, that also, even the help was wrong :-(
but now I got it - excel uses the german expression and vb the englis
and a mix of both...

thanks anyway!!