To find the Maximum and Minimum in a long list of data in Excel, one effective way isat 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.
Then switch to Formulas tab, click AutoSum in Function Library section and select Max in the.
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.
In the similar way you can also single out thein the cell O2. It’s very practical if there are mountains of data in your sheet.