DMax with No Criteria

  • Thread starter Thread starter Paul Kraemer
  • Start date Start date
P

Paul Kraemer

Hi,

I am using Excel 2007. I have a range of cells in which I want to find the
largest (numerical) value in one particular column. I would like to use the
..DMax function. The online help says that it has three parameters that are
all required. The third parameter is a criteria. Unless I am missing
something, I don't have a criteria. I simply want the .DMax function to
return the largest value in the column I specify.

Can anyone tell me what I should use for the criteria? Or is the a function
other than .DMax that might be simpler to use in this situation?

Thanks in advance
Paul
 
You don't need DMAX.

Try the following:-

=MAX(D5:D31)

- where D5:D31 is the range of cells for which you want to find the largest
(numerical) value.

Please hit yes if my comments have helped.

Thanks.
 
Hi,

There really appears to be no reason to use a Dfunction here, but you can.
If you do you need a criteria range with the title of the column (in this
case any column) and a single blank cell below that title. The two cells
become the criteria range.
 
Back
Top