Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

=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

Check out our Excel Resources

Re: =Max

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.