» 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:
- Windows XP for Dummies
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Guide to Financial Reporting and Analysis
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.
