Re: Excel: need a "maxif" function!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: R.VENKATARAMAN ($$$$vram26_at_vsnl@@@@.net&&&)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 15:44:20 +0530

is there not a <dmax> function which
"Returns the largest number in a column in a list or database that matches
conditions you specify"

see help with key word as dmax

Nick <Nick@discussions.microsoft.com> wrote in message
news:BE1F0CFC-65E7-450E-93A8-F620B6B13392@microsoft.com...
> I need a function similar to "sumif", but instead of summing certain
values,
> will select the largest value from an array that is a constrained by
values
> in a separate column of the array. does anyone have any ideas on this??

Relevant Pages

  • Re: KirbyBase
    ... creating objects from the database records was much easier. ... Hal, I don't know if you have had a chance to take a look at the beta yet, but I basically tried to implement a uniform way to specify one-to-one links, one-to-many links, and calculated fields in the ... I suppose it would in effect be embedding an array where all the ... My first couple of attempts at adding more complexity to KirbyBase did not honor this concept. ...
    (comp.lang.ruby)
  • Re: Trying to find a max value with criteria
    ... There is no MAXIF function, but you can use an array ... > the "dmax" function but it will give me the max value of the combined list ... Excel 2000 user. ...
    (microsoft.public.excel.worksheet.functions)
  • dMax
    ... I have a question regarding DMax (I think this is the expression I need ... My database has several families, each which have a unique ID number ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Auto-Line-Numbering
    ... for each new line that is put into the database. ... with the 'dmax' statement and no luck. ... This as the default value of the pertinent text box should work: ...
    (microsoft.public.access.forms)