This function examines a list of information and produces the largest value from a specified column.
Syntax:
=DMAX(DatabaseRange,FieldName,CriteriaRange)
The Database Range is the entire list of information you need to examine, including the field names at the top of the columns.
The Field Name is the name or cell, of the values to pick the Max from, such as "Points Scored" or D3
The Criteria Range is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis for selecting the records, such as the Name of the candidate or Subject
The second set of information is the actual record, or records, which are to be selected, such as Durga as a Candidate's Name, or maths as Subject.
Example:
Here is the video tutorial of the same for clear understanding.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at dptutorials15@gmail.com