Use Excel’s MAX function to find the maximum value. Use MAX, MATCH, and ADDRESS to locate the cell address of a column’s highest value.
- To start, we look up the highest number in column A using the MAX function.
2. Next, we utilize the MATCH function to locate the maximum value’s row number.
A reduction of the MATCH function is =MATCH(12,A:A,0), 7. The largest value in column A is returned by the MATCH function. To return an exact match, set the third argument to 0.