Changes

= DMAX(database, field, criteria)=

<div style="font-size:30px">'''DMAX (Array,Field,Criteria)'''</div><br/>

*Where 'database' is the range of cells that makes up the list or database

*Where 'Array' is the range of cells that makes up the list or database

*'field' shows which column is used in the function and

*'Field' shows which column is used in the function and

*'criteria' is the range of cells that contains the specified condition.

*'Criteria' is the range of cells that contains the specified condition.

DMAX()displays the largest number in a column of a list or database that matches the specified criteria.

DMAX(),returns the maximum value from selected database entries.

== Description ==

== Description ==

DMAX(database, field, criteria)

DMAX (Array,Field,Criteria)

This function returns the largest number from the database that satisfies the given condition.

*This function returns the largest number from the database that satisfies the given condition.

*A 'field' argument can be expressed as "Salary" (a column name) or 3(position of the column).  

*A 'Field' argument can be expressed as "Salary" (a column name) or 3(position of the column).  

*Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.

*Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.

*The Criteria columns should not overlap the list of data.

*The Criteria columns should not overlap the list of data.