DMIN function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
DMIN
Returns the minimum (lowest) value in a column of a Calc 'database' table, in rows which meet specified criteria.
Syntax:
DMIN(database_table; field; criteria_table)
where
- 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.
Example:
In this spreadsheet:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Grade | Age | Distance to School | Weight |
| 2 | Andy | 3 | 9 | 150 | 40 |
| 3 | Betty | 4 | 10 | 1000 | 42 |
| 4 | Charles | 3 | 10 | 300 | 51 |
| 5 | Daniel | 5 | 11 | 1200 | 48 |
| 6 | Eva | 2 | 8 | 650 | 33 |
| 7 | Frank | 2 | 7 | 300 | 42 |
| 8 | Greta | 1 | 7 | 200 | 36 |
| 9 | Harry | 3 | 9 | 1200 | 44 |
| 10 | Irene | 2 | 8 | 1000 | 42 |
| 11 | |||||
| 12 | |||||
| 13 | Name | Grade | Age | Distance to School | Weight |
| 14 | 2 |
DMIN(A1:E10; "Distance to School"; A13:E14)
- returns the maximum distance to school that any child in the second grade has to travel (300, for Frank).
DMIN(A1:E10; 4; A13:E14)
- returns the same result.
DMIN(A1:E10; D1; A13:E14)
- also returns the same result.
Issues:
The OOo2.3 Help implies that 0 as a field will include the entire database table. This seems to be wrong - only the maximum in a single column can be found.
See Also
