DMIN()
Syntax. DMIN(database,field,criteria)
Definition. This function returns the smallest number from a column in a list or database that matches the specified conditions.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Background. Use the DMIN() and DMAX() functions to find the smallest or largest value, respectively, in a database based on certain criteria. DMIN() returns a value from a database, such as the smallest sales for a product within the past five years.
Example. Your wholesale company is doing well and the sales are high. However, you want to know which product ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
