Find cell which returned maximum value in formula

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
 
Back
Top