How to find the maximum value in excel

Method to find the maximum value: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=max (specific value range)" in the cell; finally press " Press the "Enter key" to find the maximum value in a certain range in the excel table.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

After you open your worksheet, there are many sets of data. At this time, you need to check which English number corresponds to the top of your number. Here mine is [C]. How many vertical rows are there in total? , here is [2-16].

Select your mouse on the result table of the maximum value, enter [=] in the top function [fx], and then enter [max(c2:c16 )], what I need to remind you here is which cells are occupied by your data table. After entering, you will find that the system will highlight the cells you automatically selected.

After selecting, click the [Enter] key. At this time, the maximum value in your data will appear in the maximum value result box you selected initially.

Related learning recommendations: excel tutorial

The above is the detailed content of How to find the maximum value in excel. For more information, please follow other related articles on the PHP Chinese website!