View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Kraemer Paul Kraemer is offline
external usenet poster
 
Posts: 34
Default 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