In this tutorial, we will learn how to find the maximum value in an Excel worksheet and locate the cell number of that value. This is a useful skill to have when you want to quickly browse the cell containing the highest value. We will use the Max function and helper functions like Address and Match to achieve this.
- Open your worksheet containing the values you want to find the maximum of.
- In an empty cell, enter the Max function: =MAX(
- Select the range of cells containing the values you want to find the maximum of and close the parentheses: =MAX(B2:B10).
- Press Enter to get the maximum value.
- To find the cell number of the maximum value, use the MAX function inside the Match function like this: =(MATCH(MAX(B2:B10),B2:B10),0). Here zero is the match type (exact match). Press Enter to get the value.
- You can use the ADDRESS function to find the cell address of the maximum value like this: =ADDRESS(MATCH(MAX(B2:B10),B2:B10),0),2). Here 2 is the column number. Pres Enter to get the value.
Using the Max, Address, and Match functions in Excel, it is easy to find the maximum value in a range of cells and locate the cell number of that value. This can save time and make it easier to browse through large worksheets.