DMax with No Criteria

[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

 

[trip_to_tokyo]

You don't need DMAX.

Try the following:-

=MAX(D531)

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

Please hit yes if my comments have helped.

Thanks.

 

[Shane Devenshire]

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.