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, then highest value will be displayed in the cell that you select.
Step 1: Open your spreadsheet in Microsoft Excel 2013.
Step 2: Click inside the cell where you want to 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.
Rather than manually typing the formula, you can also select it by clicking the Formulas tab, clicking AutoSum, then clicking Max.
Would you also like to learn how to find the average value in a range of cells? This article will show you the process.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.