=Max
Posted by Paul B. on January 24, 2001 1:01 PM
I have a worksheet that I want to know the maximum amount in column D, =max(D:D) works for this, is there any way to have it show what cell that the max valve is in? If the max was in cell D:125 I would like this info to be displayed in the cell with the =max function or in a cell next to it. Thanks Paul B
Posted by Mark W. on January 24, 2001 1:37 PM
=CELL("address",INDEX(D:D,MATCH(MAX(D:D),D:D,0)))
...but it will only show the cell reference of the
1st occurrence of the max value.
