Description Uses specified criteria to select records from a database, then displays the highest number value found in a specified field of the selected records.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DMAX ( database, field, criteria)
| Argument | Description |
|---|---|
| database | A reference to a range containing data that the function searches. |
| field | The column within database that contains the maximum value you want to find. |
| criteria | A reference to a range containing search criteria. |
Remarks If there are no numeric values in field in the selected records, DMAX will display 0.
Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 32460:
DMAX(A1:D8,"Commissions 96",B10:B11)
See Also DAVERAGE, DCOUNT, DCOUNTA, DGET, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
