Find cell which returned maximum value in formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

De - 24 Oct 2006 22:31 GMT

Signature

Reply to this Message

Paul B - 24 Oct 2006 23:21 GMT

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

Signature

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

Reply to this Message

De - 26 Oct 2006 20:49 GMT

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.

Signature

> 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

Reply to this Message

Paul B - 27 Oct 2006 00:54 GMT

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

Signature

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
[quoted text clipped - 3 lines]
> >
> > will show the first one if there are more than one

Reply to this Message

Rate this thread: