It is usually possible to use a range of data to get the maximum and minimum value of in Excel. Also, it is useful to know how to find the maximum and minimum value of a group of cells in Microsoft Excel . For this reason, in this tutorial we show you a series of specifications and all the steps so you can achieve it.
Index( )
- What specifications must the group of cells meet in order to use the MIN and MAX function?
- Must be the same data class
- find yourself grouped
- What is the way you can execute the MINIF function in your Excel app?
- from Windows
- with website
- Using the app
- How can you use the MAXIF function in your spreadsheet cells?
- Con Windows
- On the website
- From the app
What specifications must the group of cells meet in order to use the MIN and MAX function?
It is important to take into account a series of specifications that the group of cells must meet to use the MIN and MAX function. In this regard, these must be of the same kind of data and be grouped. Only then can you apply the formula to obtain the maximum and minimum value without problems.
Must be the same data class
The values you are going to reference must be of the same data class. Therefore, if you have a group of cells with numeric and alphanumeric values , you will not be able to apply the formula correctly. You can find the maximum and minimum value of various groups that make up different books.
find yourself grouped
It is important that the values are grouped in one or more tables. Likewise, they must be associated with other elements in order to apply a certain condition or filter data. It is even possible to add or subtract the maximum or minimum value of each data group if you wish.
What is the way you can execute the MINIF function in your Excel app?
There are several ways in which you can execute the MIN function. YES in your Excel App. In this sense, you can do this procedure from Windows, with the website using your email account or using the application. Either way, you will get the result quickly and efficiently.
from Windows
The MIN.IF.SET function allows you to obtain the minimum value of a series of elements taking into account a criterion or condition. It is possible to execute the MIN.SI function from Windows. To do this, open the Microsoft Excel application from the Office suite.
Once you access Microsoft Excel, click on ‘File’ and select ‘Open’. Locate the spreadsheet with the group of cells and press ‘Open’. Also, you can make a table in Excel and add the necessary data. Place the cursor in an empty cell, type =MIN.IF.SET(A2:A11, B2:B11, 3) and press ‘Enter’.
Excel checks which criteria match the value 1 in column B. If so, it evaluates which is the maximum value based on column A . Consequently, a result is issued that will depend on the expressed condition or criterion included in the formula.
with website
Also, you can find the minimum value with the website. To do so, go to the Office 365 website and sign in with your Microsoft email account. Then click on the Excel icon found on the left sidebar. Click on ‘Load and open’ and locate the file containing the dataset.
Place the cursor in an empty cell. Next, click on the ‘fx’ button which is used to add formulas and functions . Select the ‘All’ category, look for the MIN.IF.SET option and press ‘OK’. Enter the reference to the cell range where you want to get the minimum value, the cell range with the conditions, and a criteria.
For example, suppose we have a list of 10 grades in column A, and column B contains the weights (1, 2, and 3). If we want to know what the minimum grade value is, the formula will be: = MIN.SI.SET (A2:A11; B2:B11; 2). Thus, the minimum value between the range that meets the weighting criterion ‘2’ will be obtained.
Using the app
It is possible to find the minimum value in Excel using the application on a mobile device. To do so, you’ll need to download the Microsoft Office app for Android. Then, find the file where you want to get the minimum value and click on it. Immediately, the option to open it with Excel will be displayed.
Once you open the app, tap on the formula bar and type =MIN.IF.SET ( and slide your finger over the range of cells. Then type ; and slide again over the second range that will serve to analyze the condition Finally, type ; and mark the condition.
How can you use the MAXIF function in your spreadsheet cells?
The procedure for using the MAXIF function on cells in your spreadsheet is almost identical to the one above. For this, you can count on the Windows system, do the steps on the website or from the application. Either way, you will find a quick and easy result.
Con Windows
It is possible to get the maximum value of a group of cells with Windows. To do this, open a spreadsheet and click on ‘fx’ and select the ‘MAX.IF.SET’ function. Click on the red arrow and drag the cursor to add the first range. Repeat the same for the criteria range, write the condition and press ‘OK’.
On the website
You can also get the maximum value on the Office 365 website. Sign in with your account, open the spreadsheet from Excel , and in the formula bar type: =MAX.IF.SET(cell_range;criteria_range;criteria). If the criteria is of type text, you must add it in quotes.
From the app
You can find the maximum value of a group of cells from the app. Open the spreadsheet, click on an empty cell and in the search bar type MAX.IF.SET (cell_range; criteria_range; criteria). Finally, click on the green checkmark icon located on the right of the screen.