DMIN (PQL - xl)

This function returns the smallest number in a column of a list or database that matches the specified conditions

  • Library: PQL \ Spreadsheet \ Database
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

DMIN(database, field, criteria)

Function Arguments

Name

Description

Type

Optional

database

Range of cells that make up the database; cell range reference

CellRange

field

Column in the database, referred to by label or index

StringOrNumber

criteria

Range of cells that specify which rows in the database are used; cell range reference

CellRange

Comments

This function is the same as the Microsoft Excel 'DMIN' function - using the same inputs, logic and outputs.