Returns the minimum value selected from a database table-like array or range using a SQL-like query.
81% OFF online library of tutorials for mastering Google Sheets
DMIN()
Description
How To Use in Sheets
DMIN(database, field, criteria)
External Links
Use the DMIN and DMAX Functions
This video show an how to use the DMIN and DMAX function, which are part of the family of database functions in Excel. The DMIN and DMAX functions respectively return the small and largest numbers in a database based on some criteria. You can also think of these two functions as a lookup function (i.e., to lookup the smallest and largest values in a table).
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.