Tip Printed from ExcelTip.com
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