Dmax is a function used to find the maximum value of a data field (Field) in the database list (Database) satisfying a given condition (Criterial). A common function in Excel. The following article will show you how to use this function.
Dmax function and example
How to use Dmax function in Excel
Function syntax: Dmax(Database, Field, Criterial)
To better understand the Dmax function, consider the following example:
For the list of student transcripts (pictured below), find the highest grade in class 9A. We use DMAX to find the highest point
With the formula for cell C10: =DMAX(B4:D9,D4,C4:C5) or =DMAX(B4:D9,”Point”,C4:C5) We get the result as shown below.
However, for more convenience, you should create an additional condition area, the Class field at the bottom to get the Criterial.
Through the above examples, you must have a better understanding of the syntax, how to use the DMAX function in Excel. Using this function you can get the maximum value of rows or columns in a given data area, so DMAX is used quite a lot in statistics and spreadsheet manipulation.
https://thuthuat.taimienphi.vn/ham-dmax-trong-excel-682n.aspx
There are many cases when it is necessary to resort to the formula for calculating percentages. To use the