Excel Function : DMAX
Returns the maximum value from selected database entries
Microsoft Excel Reference Page
Syntax and Description of the DMAX Excel Function
The DMAX function in Excel returns the largest value from a column of data. The syntax for the DMAX function is as follows: =DMAX(database, field, criteria) where database is a range of cells that contains the data, field is the column number that contains the data you want to find the maximum value of, and criteria is a range of cells that contains the criteria you want to use to filter the data.
About DMAX Excel Function
The DMAX function returns the largest value from the selected database. The function uses the following arguments: DMAX(database, field, criteria) Database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column. Field: The column in the database that you want evaluated to find the maximum value. Criteria: The range of cells that contains the conditions you specify. The DMAX function evaluates the field in the database for all records that satisfy the conditions.