Microsoft Office Tutorials and References

In Depth Information

**Finding Highest and Lowest with DMIN and DMAX**

The criterion specifically states to use all records where the Final Grade is

greater than 89 (>89). You can specify >=90 with the exact same result.

Finding Highest and Lowest

with DMIN and DMAX

The DMIN and DMAX functions find the minimum or maximum value,

respectively, in a database column, for just the rows that match the criteria. Figure

17-12 shows how these two functions can find the highest and lowest grades

for English Literature.

The formulas in cells F8 and F10 are practically identical. Here is the formula

in cell F8:

=”The highest grade in “ & $F$3 & “ is “ &

DMAX(Students,”Final Grade”,$F$2:$F$3)

Figure 17-12:

Calculating

the highest

and lowest

grades for

a specified

class.

Finding Duplicate Values with DGET

DGET is a unique database function. It does not perform a calculation but

rather checks for duplicate entries. The function returns one of three values:

✓
If one record matches the criterion, DGET returns the criterion.

✓
If no records match the criterion, DGET returns the #VALUE! error.

✓
If more than one record matches the criterion, DGET returns the #NUM!

error.