If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DMax with No Criteria
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 |
#2
|
|||
|
|||
DMax with No Criteria
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. "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 |
#3
|
|||
|
|||
DMax with No Criteria
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 |
Thread Tools | |
Display Modes | |
|
|