The DMIN function in Excel is a powerful tool that allows users to extract the smallest value from a set of database entries based on specified criteria. This function is particularly useful in situations where you are working with large datasets and need to find minimum values without manually sorting or filtering data. By utilizing DMIN, users can streamline data analysis and make informed decisions based on their findings.
Syntax
DMIN(database, field, criteria)
- database: The range of cells that make up the database, including the headers.
- field: Indicates which column to evaluate, specified either as a column label (e.g., “Age”) or its index number (e.g., 2 for the second column).
- criteria: A range that defines the conditions that must be met to include an entry in the evaluation.
Example #1
=DMIN(A1:C10, "Sales", E1:E2)
This function selects the smallest value from the “Sales” column (B) within the database defined by cells A1:C10. If the criteria set in cells E1:E2 specifies a certain date range, DMIN will return the minimum sales figure for that period. For example, if the minimum sales within that range is $150, the result will be $150.
Example #2
=DMIN(A1:C10, 3, E1:E2)
Here, the function retrieves the minimum value from the third column (C) of the specified database (A1:C10) based on the criteria in E1:E2. Suppose the minimum value in column C is 30; thus, the returned value would be 30.
Example #3
=DMIN(A1:C10, "Age", F1:F2)
In this instance, DMIN finds the smallest value in the “Age” column (A) from the database referenced by A1:C10, considering the criteria in F1:F2 which may specify conditions like a specific department. If the minimum age meeting the conditions is 22, the result would be 22.
Error handling
- VALUE!: This error occurs if a non-numeric value is used in the field argument (e.g., referencing a text label instead of a number).
- NUM!: This message appears when the specified field argument is invalid, such as when an index is out of range for the database.
- N/A!: This error indicates there are no records matching the supplied criteria, thus no minimum value could be found.