» 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:
- Analyzing Markets, Products, and Marketing Plans
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- PowerPoint® 2002 For Dummies®
- Special Edition Using Microsoft Office XP
- Windows XP Annoyances
No comments have been submitted.
