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
