DMAX Function
The DMAX function is used to find the maximum value from a list of items from a table/database range.
Formula:
=DMAX(DatabaseRange,FieldName,CriteriaRange)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field in which the maximum value has to be found and CriteriaRange is the name of the FieldName.
Video Tutorial:
Let us find the maximum value from a list of items from the table/database, using DMAX function, with the help of the below video
