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





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



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 *


× 1 = three

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>