Buzz
While MIN() function helps you find the smallest value among values, DMIN() function returns the smallest value based on a specified condition. When you need to fetch the smallest value under certain conditions, you should use DMIN(). If you are unfamiliar with the syntax and usage of DMIN() function, follow the upcoming article.
The article describes the syntax and usage of DMIN() function in Excel.
Description
DMIN() function helps you find and return the smallest value in a column within a list or database that satisfies the condition you specify.
Syntax
=DMIN(database,field,criteria)
Where:
- database: It refers to the list or database including column headers.
- field: The field (column) from which you want to retrieve the maximum value. You can directly input the column header in double quotes or a number representing the column's position in the database: 1 for the first column, 2 for the second column... You can also input the cell containing the column header to use, for example, B3, C1...
- criteria: It represents the range of cells containing the condition. You can choose any range as long as it contains at least one column header and the cell below the column header containing the condition for the column.
Note
- It's advisable to place the criteria range on a worksheet so that when adding data, the range containing the criteria remains unchanged.
- The criteria range needs to be separate and should not be inserted into the list or database being processed.
- The criteria must include at least one column header and a cell containing the condition below the column header.
Example
Find the lowest salary of employees with Hometown in Quảng Ninh in the following data table:
You need to create a criteria range with the header being Hometown and the condition being Quảng Ninh.
Applying the DMIN() formula: =DMIN(B8:F14,F8,E5:E6)
B8:F14 represents the list, the database range.
F8 represents the Salary column to find the minimum value.
E5:E6 represents the criteria range you just created.
After that, you will get the result as follows:
The syntax and usage of DMIN() function are very simple, you just need to apply it to appropriate requirements. The function will greatly assist you in data analysis in Excel. Wish you success!
