Find cell which returned maximum value in formula

[Guest]

--
De

 

[Paul B]

De, try this, =CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0)))

will show the first one if there are more than one

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thanks, Paul, but I found this hard to follow. Excel kept returning that I
had disabled macros but your formula didn't look like a macro to me. I must
have been doing something wrong.

 

[Paul B]

De, not know why you would get that, if you put the formula in a cell, not
in column A, it should return the cell address with the max value in column
A

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003