Slider

How to Single Out the Maximum and Minimum in Excel

Date:2019-7-30 Author:Cordelia

To find the Maximum and Minimum 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.

Click the cell you want to output the result.

How to Single Out the Maximum and Minimum in Excel

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

How to Single Out the Maximum and Minimum in Excel

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 Single Out the Maximum and Minimum in Excel

In the similar way you can also single out the minimum in the cell O2. It's very practical if there are mountains of data in your sheet.

How to Single Out the Maximum and Minimum 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 *