How to Use Excel DMAX Function (2 Easy Examples)

Excel is a powerful software as it has predefined functions and numerous features. These functions make the excel experience smoother and more efficient. Just like that, the DMAX function is one of the Excel worksheet functions. After that, in this article, I am going to explain how to use DMAX function in Excel.

The below image shows an overview of the use of DMAX function. Subsequently, I will share examples of using DMAX function in the following article.

Download Practice Workbook

You can download the practice workbook here.

Introduction to DMAX Function in Excel

The DMAX function falls under the category of Excel Database functions. This function finds and returns the largest value from the selected entries of a database.

Syntax:

Returns the maximum/ largest value in a specified field from selected database entries that match the provided condition.

Arguments Explanation:

The criteria can be a numerical value, text, or an expression.

2 Easy Examples to Use DMAX Function in Excel

There are some common uses of this function. I am going to provide examples based on single criteria and multiple criteria. Moreover, I have a dataset containing information about the sales of a company, where the attributes are Product Name, Region, Quantity, and Sale Price. For this article, my Excel version is Microsoft Excel 365. You can use any available Excel version.

1. Using Single Criteria

You can use only one criterion when applying this function. For this method, I have a criterion to find out the Maximum Sale of the product Tablet.

Steps:

• First of all, select cell G9.
• After that, type the following formula:

• Then, press ENTER.
• Therefore, you can see the result.

Read More: How to Use Database Functions in Excel (With Examples)

2. Using Multiple Criteria for DMAX Function

You can also find maximum value using multiple criteria. The criteria range includes Product Name, Region, and Quantity. In addition to using multiple criteria, I am going to use Field by Name, and Field by Index methods. You can also use these methods using single criteria.

i. Field by Name

You can use the label as the field of the function. The DMAX function will match the label with the database itself.

Steps:

• In the beginning, select cell G10.
• After that, type the following formula:

• Then, press ENTER.
• As a result, you can see the result.

ii. Field by Index

You can also use the index number to indicate the column in the field of the function.

Steps:

• In the first place, select cell G10.
• After that, type the following formula:

• Then, press ENTER.
• Hence, you can see the result.

Read More: How to Use DMAX Function in Excel with Multiple Criteria

Things to Remember

• While using the DMAX function, you can not reference a value in a different worksheet or workbook.
• Also, you can not reference a value in a different range.
• Moreover, it is not a case-sensitive function.

Practice Section

On the right side of each worksheet, you will find a practice section to practice on your own.

Conclusion

In this article, you learned how to use Excel DMAX function with suitable examples. Follow our ExcelDemy page for regular blogs related to Excel. You can suggest your thoughts about this article in the comment section below.

Related Articles

• How to Calculate Standard Deviation with IF Conditions in Excel
• Use DSUM Function with Dynamic Criteria in Excel
• How to Use DPRODUCT Function in Excel (6 Practical Examples)
• Use DVAR Function in Excel (2 Suitable Examples)
• How to Use Macaulay Duration Formula in Excel (2 Easy Methods)
• Use DSTDEV Function in Excel (3 Practical Examples)
• How to Determine If a Number Is Even in Excel (4 Suitable Ways)