Thank you for this but this file is only an 07 file. Unfortunately when you open the 03 application and a file created in 03 this doesn't work.
Could something be wrong with my 03 application itself? ________________________________ From: ashish koul <koul.ash...@gmail.com> To: excel-macros@googlegroups.com Sent: Fri, November 19, 2010 9:25:31 AM Subject: Re: $$Excel-Macros$$ Need a MAXIF type formula Check the attachment see if it works for you On Fri, Nov 19, 2010 at 10:27 PM, ratu elissa <masihgadis...@gmail.com> wrote: i don't really understand what you ask for > > > >On Fri, Nov 19, 2010 at 11:45 PM, None <n8dine4ma...@yahoo.com> wrote: > >I need a MaxIf type of formula that will work with Excel 97 and Excel 2003. >Thanks. >> >>I have two worksheets that have similar data in them for Col A-C. Sheet 1 >>has >>numbers in col D. What I need in Col D on Sheet 2 is a formula that will >>find >>the max of this column if the first three columns match. The result should >>be: >>Sheet 2 cell D3 = 10 >>Sheet 2 cell D4 = 10 >>Sheet 2 cell D5 = 6 >>Sheet 2 cell D6 = 7 >> >>Data: >>Sheet 1: >>Col A Col B Col C Col D >>9944455123 AB123-8877445566 AB 1 >>9944455777 AB123-8877445566 AB 5 >>9944455123 AB123-2277445500 AC 10 >>9944455123 AB123-8877445566 AB 4 >>9944455123 AB123-8877445566 AB 4 >>9944455123 AB123-8877445566 AB 2 >>9944455123 AB123-8877445566 AB 1 >>9944455123 AB123-8877445566 AB 3 >>9944455123 AB123-8877445566 AB 10 >>9944455777 AB123-8877445566 AB 7 >>9944455111 AB123-2277445500 AC 5 >>9944455123 AB123-8877445566 AB 4 >>9944455123 AB123-8877445566 AB 8 >>9944455123 AB123-8877445566 AB 1 >>9944455123 AB123-8877445566 AB 5 >>9944455123 AB123-8877445566 AB 10 >>9944455123 AB123-2277445500 AC 4 >>9944455123 AB123-8877445566 AB 4 >>9944455123 AB123-2277445500 AC 2 >>9944455111 AB123-2277445500 AC 1 >>9944455123 AB123-2277445500 AC 3 >>9944455777 AB123-8877445566 AB 1 >>9944455123 AB123-8877445566 AB 5 >>9944455123 AB123-8877445566 AB 5 >>9944455123 AB123-8877445566 AB 4 >>9944455123 AB123-8877445566 AB 8 >>Sheet 2: >>Col A Col B Col C Need formula here >>9944455123 AB123-8877445566 AB >>9944455123 AB123-2277445500 AC >>9944455111 AB123-2277445500 AC >>9944455777 AB123-8877445566 AB >> >>-- >>---------------------------------------------------------------------------------- >> >>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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> >-- >---------------------------------------------------------------------------------- > >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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
