Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lucas Ward   on Jan 07 In MS Office Category.

  
Question Answered By: Isaac Williams   on Jan 07

Of course it gets better:

=LARGE((((A5:A41>=DATEVALUE("August 15,
2005"))*1)*((A5:A41<=DATEVALUE("August 13, 2005"))*1)*(B5:B41)),1)

entered as an ARRAY formula (Ctrl+Shift+Enter as you enter  it so that
curly braces appear round it).

Now you can control better the start  and end  dates; this time  it
INCLUDES the dates  specified because I've used <= and >=, but you can
adjust that to taste.
No need to compensate for which row the data starts on, no fighting
with the Match function.
UDF next week perhaps

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Need to create function smiliar to DMAX Or get search suggestion and latest updates.


Tagged: