How to Find the Highest Value in Excel

Excel
Written By Jonathan Burks

Summary

Finding the highest value in a range of cells in Excel is straightforward with the MAX function. This guide provided step-by-step instructions to utilize the MAX function, offering you another tool to use in your data analysis endeavors.

  1. Open your Excel worksheet and identify the range of cells where you want to find the highest value.

  2. Click on an empty cell where you want the result to be displayed.

  3. Type =MAX( in this cell to start the MAX function.

  4. Click and drag your mouse over the range of cells that you want to find the highest value from, or manually type in the range (for example, A1:A10).

  5. Close the parentheses ) and press Enter. Excel will calculate the highest value in the specified range and display it in the cell where you typed the formula (source).

Here's what the complete formula might look like: =MAX(A1:A10)

Jonathan Burks
Previous

Unlocking the Power of Macaulay Duration in Microsoft Excel
Next

How to Turn Off Auto Complete in Microsoft Excel and Google Sheets