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