Hi yesterday I posted a question which was quickly answered, then today I discovered that I'd asked the wrong question! Sorry about that.
I've attached a workbook which illustrates the problem. I need to find the max (or min) values in a range of dates in an array, based on three variables.
I will greatly appreciate your help!
Last edited by jrtaylor; 08-16-2012 at 02:48 PM. Reason: solved
Put in G2, array-enter (press CTRL+SHIFT+ENTER) to confirm the formula:
=MAX(IF((Highs!$A$2:$A$163>=A5)*(Highs!$A$2:$A$163<=E5),OFFSET(Highs!$A$2:$A$163,,MATCH(C5,Highs!$1:$1,0)-1)))
Copy down
Thank you! Perfect!
welcome, great to hear. btw, you could also click the little star at the bottom left of my post to express your satisfaction with the response
There you go. I hope it worked. I'll start doing this from now on!
Yes, it did. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks