DMax with No Criteria

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
 
T

trip_to_tokyo

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top