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
