Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Find the Maximum or Minimum Value in Excel

Date:2020-4-4 Author:Cordelia

To find out the Maximum and Minimum value in a long list of data in Excel, one effective way is sorting data at first and then find the one you want in the beginning or in the end. But if you don’t want any change to the order of the data, there’s another simple method.

1. Click the cell you want to output the result.

How to Find the Maximum or Minimum Value in Excel

2. Switch to Formulas tab, click AutoSum in Function Library section and select Max in the drop-down list.

How to Find the Maximum or Minimum Value in Excel

3. You can see the formula is filled into the cell N2 automatically. “B2:M2” refers to the data range, you can adjust it to meet your actual needs. Then press Enter to produce the result.

How to Find the Maximum or Minimum Value in Excel

4. You can also single out the minimum value in the cell O2 in the similar way. It’s very practical if there are mountains of data in your sheet.

How to Find the Maximum or Minimum Value in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *