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:
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:
No comments:
Post a Comment