Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get first column number in range in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to get last row in numeric data in Excel
  • To count total rows in a range in Excel

Data Analysis Examples

  • Create Scatter Chart in Excel
  • Reverse List in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Excel Pie Chart

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation must not contain
  • Excel Data validation exists in list
  • Excel Data validation must begin with
  • Excel Data validation specific characters only

Excel MAX, MATCH and ADDRESS function illustration

by

Locate Maximum Value in Excel

This example teaches you how to find the cell address of the maximum value in a column.

1. First, we use the MAX function to find the maximum value in column A.

Worked Example:   Find longest string in column in Excel

2. Second, we use the MATCH function to find the row number of the maximum value.

Explanation: the MATCH function reduces to =MATCH(12,A:A,0), 7. The MATCH function returns the position of the maximum value in column A. Set the third argument to 0 to return an exact match.

Worked Example:   Two-way lookup with VLOOKUP in Excel

3. Finally, we use the ADDRESS function to return the cell address.

Worked Example:   How to get address of last cell in range in Excel

Explanation: the ADDRESS function reduces to =ADDRESS(7,1), $A$7. The first argument specifies the row number. The second argument specifies the column number.

Post navigation

Previous Post:

Convert text string to valid reference in Excel using Indirect function

Next Post:

Left Lookup in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • UNICODE function: Description, Usage, Syntax, Examples and Explanation
  • Remove last characters from right in a cell in Excel
  • How to count keywords in a range of cell
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • How to get last word in a cell in Excel
  • Count times in a specific range in Excel
  • Get fiscal year from date in Excel
  • List holidays between two dates in Excel
  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • How to join date and text together in Excel
  • How to calculate annual compound interest schedule in Excel
  • Calculate loan interest in given year in Excel
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • ACCRINTM function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles