» Find the address of the max value in range in Microsoft Excel
CATEGORY - Information Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Mastering Excel 2000 (for beginner)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The Guide to Understanding Financial Statements
- Special Edition Using Microsoft Outlook 2002
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Excel 2002 Simply Visual
No comments have been submitted.
