Hi, I am assuming that your first unique invoice numberis in A2.
Format B2 of the same sheet as Date, then enter the following: =Sumproduct(Max((OtherSheet!A2:A100=A2)*(OtherSheet!B2:B100))) Then copy down to the end of your unique data. If you can't get this to work, post again with a sample workbook. Regards - Dave. Date: Tue, 14 Sep 2010 17:33:44 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Need most recent date To: excel-macros@googlegroups.com I have a list of dates in one sheet. Col A = Invoice Number Col B = Payment Date There will be multiple rows for the same invoice number as payments are made against it until it is paid in full. Some of these rows will contain dates and some won't. The next sheet has the unique list of invoice numbers (meaning they don't repeat). I need a formula that will look at the first sheet and give me the most recent date if there is one. This is in Excel 2003. Thanks so much. -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
