Navigation:  Formulas and functions > Functions from A to Z > DMAX (database function)

Syntax:

DMAX(DatabaseArea, Column, SearchCriteriaArea)

Description:

This returns the largest of those values in a column of a database area that match the conditions specified in the criteria area.

For more information on the use of database functions, see Working with database functions.

DatabaseArea is the cell range that contains the database. The first row of DatabaseArea must contain labels for the database columns (e.g., Amount, Price, etc.).

Column is the desired column of the database area. You can specify Column by its relative column number or by its column label within double quotation marks (e.g., "Amount", "Price", etc.).

CriteriaArea is a cell range containing one or more conditions that have to be fulfilled. The first row of CriteriaArea has to contain column labels (e.g., Amount, Price, etc.).

See also:

MAX, DMIN