I need the max number in Col D on sheet 1 if the data in sheet 2 Col A-C is found in Sheet 1 Col A-C.
________________________________ From: ratu elissa <masihgadis...@gmail.com> To: excel-macros@googlegroups.com Sent: Fri, November 19, 2010 8:57:24 AM Subject: Re: $$Excel-Macros$$ Need a MAXIF type formula 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 -- ---------------------------------------------------------------------------------- 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
