Locate Maximum Value

 

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.

Max Function in Excel

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

Match Function in Excel

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.

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

Address Function 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.