Module 23 : DMAX Function

23.1 DMAX Function The DMAX function in Excel will return the largest number in a column or database that contains the criteria you set. DMAX is part of the Database function group that performs basic tasks in a large field of data. The formula is written as: =DMAX(database, field, criteria) Database - This is the range of cells that make up your database or list. Field - This is the column that you would like to return data from. You can either enter the column name bet...

Lessons

Find out how we can help train your staff

Or buy an individual course