Advanced Excel Formulas

Advanced Excel Formulas – DMAX Function Description With Example

[ResponsiveRect]
Advance Excel Formulas

To calculate largest Value Of Stock of a particular Brand of bulb.

Criteria Range Is E23:E24

Dmax Function

DATABASE FORMULA – DMAX Function

What Does It Do ?
This function examines a list of information and produces the largest value from a specified column.

Syntax
=DMAX(DatabaseRange,FieldName,CriteriaRange)

Description For DMAX Function

  • The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns.
  • The FieldName is the name or cell, of the values to pick the Max from, such as “Value Of Stock” or I3.
  • The CriteriaRange is made up of two types of information.
    The first set of information is the name, or names, of the Fields(s) to be used as the basis for selecting the records, such as the category Brand or Wattage.
    The second set of information is the actual record, or records, which are to be selected, such as Horizon as a brand name, or 100 as the wattage. .

Formatting
No special formatting is needed.

GenronTech Header-Cartoon

[ResponsiveRect]

 


Examples 1

The largest Value Of Stock of a particular Product of a particular Brand.

CrietriaCriteria Range Is E49:E50

The largest value is :  Answer for DMAX=DMAX(B3:I19,I3,E49:F50)

This is the same calculation but using the name “Value Of Stock” instead of the cell address.

Answer for DMAX =DMAX(B3:I19,”Value Of Stock”,E49:F50)


Examples 2

The largest Value Of Stock of a Bulb equal to a particular Wattage.

Example1Criteria Range Is E60:E61

The largest Value Of Stock is : Answer =DMAX(B3:I19,”Value Of Stock”,E60:F61)


Examples 3

The largest Value Of Stock of a Bulb less than a particular Wattage.

Excel AnswerCriteria Range Is E67:E68

 

The largest Value Of Stock is :  Answer =DMAX(B3:I19,”Value Of Stock”,E67:F68)

GenronTech Header-Cartoon

Advanced Excel Formulas Index

  1. Jump To Advance Excel Formulas Main Menu
  2. Jump To Database Function
  3. Jump To Date and Time Function
  4. Jump To Financial Function
  5. Jump To Informational Function
  6. Jump to Logical Function
  7. Jump To Math Function
  8. Jump to Statistical Function
  9. Jump To Engineering Function
  10. Jump To Text Function

Leave a Reply

Your email address will not be published. Required fields are marked *