:DMIN function filters the smallest value that meets the conditions-Table skills免费ppt模版下载-道格办公

DMIN function filters the smallest value that meets the conditions

Picture and text skills
Case

Returns the minimum value of the selected database entry that satisfies the specified condition.

Syntax
DMIN(database,field,criteria)
￭Database A range of cells that constitutes a list or database. A database is a list containing a set of related data, which contains behavioral records of related information.

Andpackage contains data as a field. The first row of the list contains the flags for each column.

￭Field specifies the data column used by the function. The data columns in the list must have a flag entry in the first row. Field can be text, that is, with quotes on both ends

MarkZhiitem, such as "age of tree" or " Yield";

Alternatively, Field can be a number that represents the position of a data column in the list: 1 for the first column, 2 for the second column, and so on.

￭Criteria is a set of cell ranges containing given conditions. Any range can be specified for the criteria parameter, as long as it contains at least one column flag and column

CellThe cell below the label for setting conditions.

The function of the DMIN function is to return the minimum value that meets the conditions .
Let me show you how to use this function to find the smallest value that meets the conditions.

￭Place the cursor at E5 and click Insert Function-Database-DMIN Function.
A dialog box will pop up with three parameters in total.

￭"Database area" is the cell area that needs to be filtered, enter B2:C9.
"Operation domain" refers to the column label, which needs to be enclosed in double quotes in English. Enter "score" here.
"Condition" is the set condition, enter E2:E3.
Click OK to get the minimum value that meets the conditions.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/DMIN-han-shu-shai-xuan-man-zu-tiao-jian-de-zui-xiao-shu-zhi.html