Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

Locate Max Value in Excel

Admin
Duration: 3:44
Submitted: 8 months ago
Views: 341

Comments (0)

Link to this video:

Description: In this video, we will learn how to locate the cell address of the maximum value in a column using the MAX, MATCH and ADDRESS functions in Excel. Finding the max value in a column can be very useful for identifying which items have been sold at the highest price or weight, for example. Table Of Content 00:00 Introduction 00:23 Locate maximum Value using MAX, MATCH, ADDRESS Function 02:40 Conclusion We will be using 3 Functions i.e. MAX, MATCH and ADDRESS Functions in excel. First Learn the syntax of MAX Function as below; =MAX(Range of Cells) In the example below, we have used this function to find the max value in column A. Now let's say you want to locate the cell address of that maximum value instead of just seeing the value itself. This is where MATCH comes in. MATCH takes two arguments: The value you're looking for and the range of cells you're looking in. So, our equation would look like this: =MATCH(MAX(Range of Cells), Range of Cells) The MATCH function will return the row number where the max value is found. Now that we have the row number, we can use ADDRESS to get the cell address. ADDRESS takes two arguments as well: The row number and column letter. So, our equation would look like this: =ADDRESS(MATCH(MAX(Range of Cells), Range of Cells), Column Letter) In the example below, we have used this function to find the max value in column A and then locate the cell address of that max value. The final result is C15, which is the cell address of the maximum value in our column. You can also use this formula to find the max value in a range of cells. Simply insert the range you want to look in between the parentheses for MAX and MATCH. Here is an example of how to find the max value in a range of cells: =MAX(A15:C17) This will return the max value from A15 to C17. Conclusion: In this video, we have learned how to locate the cell address of the maximum value in a column using the MAX, MATCH and ADDRESS functions in Excel. This can be a very useful tool for determining which items have been sold at the highest price or weight. The final result is C15, which is the cell address of the maximum value in our column. You can also use this formula to find the max value in a range of cells. Simply insert the range you want to look in between the parentheses for MAX and MATCH. Thanks for watching!