The DMAX function returns the maximum value in a field, from a set of records that match criteria. Use the DMIN function to get the minimum value.
Purpose of Excel DMAX Function
Get max from matching records.
Return value
The maximum value in a given field.
Syntax
=DMAX (database, field, criteria)
Arguments
| Arguments | Description | Remarks |
| database | Database range including headers | Mandatory |
| field | Field name or index to count | Mandatory |
| criteria | Criteria range including headers | Mandatory |
Usage notes
- DMAX supports some wildcards in criteria.
- Criteria can include more than one row (as explained above).
- The field argument can be supplied as a name in double quotes (“”) or as a number representing field index.
- The database and criteria ranges must include matching headers..
Availability
Since 2007 for Windows.
Since 2011 for Mac.