How to Find the Highest Value in Excel 2013

Excel 2013 offers a large number of useful formulas that will help you to find or calculate important information from your spreadsheet data.

Whether you need to compare values between cells, or you need to add up a group of values, Excel has a simple way to accomplish what you need.

One other useful function is the Max function, which will tell you the highest value among a range of cells that you select.

If you have used formulas before, then the Max function should be relatively familiar. If not, then you should read our article about Excel 2013 formulas. But if you just need to know how to determine the highest value in a range of cells, follow our guide below.

Using the Max Function in Microsoft Excel 2013

The steps in this article will show you how to find the highest value among a group of consecutive cells that you select from one of the columns in your spreadsheet. Once you enter the formula that we will be defining, the highest value will be displayed in the cell that you select.

If you want to use some other formulas, then our article about how to subtract in Excel can show you a really useful one.

Step 1: Open your spreadsheet in Microsoft Excel 2013.

Step 2: Click inside the cell where you want to display the highest value.

select the cell where you will display the highest value

Step 3: Type =MAX(XX:YY), where XX is the first cell in the range of cells that you are comparing, and YY is the last cell in the range. Press Enter on your keyboard after you have finished entering the formula. In my example image below, the first cell is A1 and the last cell is A8.

enter the max formula

Rather than manually typing the formula, you can also select it by clicking the Formulas tab, clicking AutoSum, then clicking Max.

alternative way to use the max formula

Now that you know how to find the highest value in Excel 2010 with the help of this formula, you can save yourself a lot of time if you had been trying to accomplish this manually.

Would you also like to learn how to find the average value in a range of cells? This article will show you the process.

Additional Sources

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy