The DMAX function with examples in Excel

The DMAX function in Excel allows you to find the maximum value in a column based on specific conditions. Here’s how it works:

1. Basic Syntax:

   • The DMAX function has the following format:

     DMAX(database, field, criteria)
     

   • Where:
     • database: The range of cells containing your data.
     • field: The column (field) in which you want to find the maximum value.
     • criteria: The range of cells that specify conditions (e.g., filtering by team name, points greater than a certain value, etc.).

2. Example 1: Using DMAX with One Condition:

   • Suppose we have a dataset with information about basketball players, including columns for “Points” and “Team.”
   • To find the max points scored by the “Mavs” team, use this formula:

     =DMAX(A5:D16, "Points", A2:D3)
     

   • This returns a value of 32, indicating the max points scored by the Mavs team.

3. Example 2: Using DMAX with Multiple Conditions:

   • Let’s find the max rebounds among players on the “Mavs” team with points greater than 20:

     =DMAX(A5:D16, "Rebounds", A2:D3)
     

   • The result is 13, representing the max rebounds for Mavs players with points exceeding 20.