How To Find The Maximum Value In Excel


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.

  1. To start, we look up the highest number in column A using the MAX function.
Max Value

2. Next, we utilize the MATCH function to locate the maximum value’s row number.

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.


Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.

Leave a Reply