» 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:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Business Plans For Dummies®
- The Guide to Understanding Financial Statements
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The Ernst & Young Business Plan Guide
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
