How to use the DMAX Formula in Excel
The DMAX formula in Excel is used to find the largest number in the database that matches the specific condition set.
- Database: Range of data within which we want to perform the analysis.
- Field: The item which we want to find within the database (e.g. price, category, etc.).
- Criteria: The given criteria that have to be matched with.
A financial analyst has a sales report of some fruit which were sold in January 2019 at a variety of rates. In his analysis he would like to determine what the maximum price was charged based on certain conditions set forth in the below tables:
* Note this table is only a sample of an example with a few data entries, and the formulas are based on the whole population of raw data which are not reflected in the example.
This is a great formula that will easily allow you to determine the maximum amount or the highest amount within a data table when we set multiple conditions. In this case, we just set two conditions. We set a condition of doing a lookup for a fruit and a lookup for logic around the number of unit sales.
I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!