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

--
Paul Kraemer

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.





"Paul Kraemer" wrote:

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

--
Paul Kraemer

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Paul Kraemer" wrote:

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

--
Paul Kraemer