Ahmed, use this in F5 in your original file, and drag down =SUMPRODUCT(MAX((A5:A1032>=VALUE(D5))*(A5:A1032<VALUE(D6))*(B5:B1032)))
Sam Mathai Chacko (GL) On Sep 25, 7:29 pm, "dguillett1" <dguille...@gmail.com> wrote: > I deleted your original but here is a sample > > From: Ahmed Honest > Sent: Sunday, September 25, 2011 9:20 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Max Value Required for Each half hour > > Dear Dguilett, > > the formula is not working please can you see in the attachment and do it for > me pleaseeee. > > Regards > Ahmed Bawazir > > On Sun, Sep 25, 2011 at 5:12 PM, dguillett1 <dguille...@gmail.com> wrote: > > If you are actually looking the highest value within the time frame, > use this array formula that must be entered using ctrl+shift+enter > > =MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000<C6),$B$5:$B$5000)) > > From: Ahmed Honest > Sent: Sunday, September 25, 2011 8:02 AM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Max Value Required for Each half hour > > Dear Group, > > Please find attach and i Need Max Value for each half hour. For further > clairifaction please revert > > -- > > Ahmed Bawazir > احمد باوزير > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > Ahmed Bawazir > احمد باوزير > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > maxperhalfhour.xls > 32KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel