Find the address of the max value in range in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/information-formulas/find-the-address-of-the-max-value-in-range-in-microsoft-excel.html">
SHARE




Data in cells A1:A10

 

      A
1 1
2 100
3 500
4 400
5 300
6 35
7 2856
8 1145
9 1495
10 1845

Formula in cell B1 =  =MAX(A:A),     Result:2856

Formula in cell B2=    =CELL(“address”,INDEX(A:A,MATCH(MAX(A:A),A:A,0)))
Result: $A$7

 

Screenshot // Find the address of the max value in range in Microsoft Excel
Find the address of the max value in range in Microsoft Excel

Please follow and like us:
7


One thought on “Find the address of the max value in range in Microsoft Excel

  1. “Como podria encotrar mediante una formula en una columna el numero maximo Anterior.

    Ejemplo: 1-2-45-46-25-75-85-47-78= 85Max , 78Max Min”

Leave a Reply

Your email address will not be published. Required fields are marked *


five − = 0

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>