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
