DMAX () function (returns conditional maximum value) in Excel
As you know, the MAX () function helps you return the largest of the input values. But if you want to get the maximum value that satisfies a given condition, the MAX () function cannot do it. To do that you need to use the DMAX () function, the DMAX () function will help you get the maximum value and satisfy the input conditions.
If you do not know the syntax and usage of the DMAX () function, you follow the article below:
Description
DMAX () is the function that returns the maximum value in a column in a list or database that satisfies the condition that you give.
Syntax
= DMAX (database, field, criteria)
Inside:
- database: list or related database including column headers.
- field: the field (column) needs to get the maximum value. You can enter the column header directly in quotation marks or some representing the column position in the database: 1 for the first column, 2 for the second column, etc., you can also enter the cell containing the required column header. Using example B3, C1 .
- criteria: is the range of cells that contain conditions, you can choose any as long as the range contains at least one column header and the cell below the column header contains conditions for the column.
Note
- You should set the criteria range on the worksheet so that when adding data, the range of conditions does not change.
- The scope of the conditions that need to be separated is not inserted into the list or database to be processed.
- Criteria must contain at least column headers and a cell containing conditions under column headers.
For example
Find the highest salary of female employees in the following data table:
Firstly, facilitating Gender as a Female.
Next apply the DMAX formula:
= DMAX (B8: F14, F8, D5: D6)
B8: F14 is the data table to find the highest salary.
F8 is the Salary column, the column to find the highest salary value.
D5: D6 is the criteria condition area.
Your results will be as follows:
The article has described, presented the syntax and with specific examples hope you will understand and know how to use the DMAX () function in Excel. Good luck!
You should read it
- How to use MAXIFS function in Excel 2016
- How to use DSUM function in Excel
- How to use COUNTIF function on Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- How to use the IF function in Excel
- Usage of Min and Max functions in Excel
- F.TEST function - The function returns the result of the F - test in Excel
- CHOOSE function combines SUM - Conditional sum in Excel
May be interested
- CHOOSE function combines SUM - Conditional sum in Excelthe following article details how to use the choose function in combination with sum- conditional sum in excel.
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- The SUMIFS function, how to use multiple conditional calculation functions in Excelthe sumifs function in excel calculates multiple conditions, combining multiple conditions.
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- How to calculate the total value based on multiple conditions in Excelto calculate conditional sum in excel, it is impossible not to mention the special calculation function that is sumif and sumifs function. software tips will guide how to use conditional sum function. please follow the following article.
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])