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 “ &
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!