How to use DMAX Function in Excel (With Examples)

By /

Excel is an incredibly powerful tool that can be used to automate and streamline a variety of tasks. One of the most popular functions in Excel is the DMAX function, which can be used to find the maximum value in a data range. In this article, we’ll explain how to use the DMAX function in Excel, as well as provide some examples of how it can be used.

You can use the DMAX function in Excel to find the max value in a column that meet one or more specific conditions.

This function uses the following basic syntax:

DMAX(database, field, criteria)

where:

  • database: The range of cells that make up the “database” of interest
  • field: The column to find max value in
  • criteria: The range of cells that contain the conditions to meet

The following examples show how to use the DMAX function in practice with the following dataset in Excel that contains information about various basketball players:

Example 1: Use DMAX with One Condition

Suppose we would like to find the max value in the “Points” column where the value in the “Team” column is Mavs.

We can type our criteria into the range A2:D3 and then use the following formula with the DMAX function in cell G2:

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

The following screenshot shows how to use this formula in practice:

The formula returns a value of 32.

This tells us that the max value in the “Points” column where the corresponding value in the “Team” column is Mavs is 32.

Example 2: Use DMAX with Multiple Conditions

Suppose we would like to find the max value in the the “Rebounds” column where the following conditions are met:

  • Value in “Team” column is Mavs
  • Value in “Points” column is greater than 20

We can type our criteria into the range A2:D3 and then use the following formula with the DMAX function in cell G2:

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

The following screenshot shows how to use this formula in practice:

The formula returns a value of 13.

This tells us that the max value in the “Rebounds” column among players on the Mavs team with a points value greater than 20 is 13.

x

Related terms:

  1. The SUBSTR Function in SAS (With Examples) How to use the SUBSTR function in SAS?
  2. How can I use the IF Function with the LEFT Function in Microsoft Excel?
  3. How do you Use SMALL IF Function in Excel (With Examples)
  4. How to Create a Lag Function in Excel ?
  5. How to use the TRANWRD Function in SAS (With Examples)
  6. How to Use the Subtotal Function in VBA (With Examples)
  7. How to use the MIN Function in SAS (With Examples)
  8. How does Pandas explode() Function work (With Examples)
  9. How to Use diff Function in R (With Examples)
  10. How to Use the Unite Function in R (With Examples)