Returns the minimum (lowest) value in a column of a Calc 'database' table, in rows which meet specified criteria.
DMIN(database_table; field; criteria_table)
- database_table is a range defining the data to be processed.
- field is the column to examine. It may be a column number (1 is the first column of the database table, 2 is the second ...) or a column header (enclosed in quotation marks ””) or a cell referring to a column header.
- criteria_table is a range containing criteria, which are used to select which rows of the database_table to examine.
The Database functions overview fully describes the use of these parameters.
In this spreadsheet: