How to select the maximum value from the table
How to select the maximum value from the table
For working with tables in the operating systemWindows uses Excel, which is part of the Microsoft Office suite. The utility has a wide functionality and allows you to perform not only the operations of adding and inserting data, but also sorting them by numerical value.
Instructions
1
To select the maximum value in severalrows or columns of the table uses the special formula "MAX". It specifies the range of values from which the maximum number is selected and displayed in the corresponding line.
2
Open the table you need in Excel, twiceby clicking on its file with the extension .xls. You can also create a new document by running the program through the "Start" - "All Programs" - Microsoft Office - Microsoft Excel and choose "Create" among the suggested options. Add the required values to the table and create a cell in which you will display the maximum value in the specified columns.
3
Place the cursor in the created cell. Then go to the formula bar, which is located above the table in the application window and put the "=" sign. Then click on the Fx icon, which is located to the left of this line.
4
In the list of suggested functions, press"Static", and then locate and select the "MAX" parameter. A window with the name "Function Arguments" opens, where you will need to specify the start and end values.
5
Click on the "Number 1" field and specify the cells in thewhich will need to select the desired number. You can do this by clicking on the start and end cells with the left mouse button or by typing the names of the cell data manually. If necessary, you can specify additional sorting options. After making the settings, click "Ok".
6
If the numerical data has been selected and entered correctly, the maximum value appears in the desired cell. You can continue working with the table or save changes to the edited file.
