Please ignore earlier attached file. Please find the correct attachment.
Regards ----- Forwarded by Dheeraj Bankoti/P&E/PLL on 05/09/2010 11:53 AM ----- Dheeraj Bankoti/P&E/PLL 05/09/2010 08:17 AM To excel-macros@googlegroups.com cc Subject Maximum Date Dear All, I have a spreadsheet containing quite a lot of data, one of the columns is date & one of the data. My user would like to see the latest rows (as this may not necessarily be current's day) on a separate worksheet. So basically I would like to write a formula in another sheet that will select maximum date & data. Sample file attachment is herewith. Regards --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient of this communication, we request you to notify the sender immediately by return email and destroy all copies and the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email is strictly prohibited. The recipient acknowledges that Punj Lloyd Limited or its subsidiaries and associated companies (collectively "Punj Lloyd Group") are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any view, opinion or advice expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Punj Lloyd Group. Although we have taken all reasonable precautions to ensure that this communication is free from viruses. We do not assume responsibility for any loss or damage arising from the use of this email. -- ---------------------------------------------------------------------------------- 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 6,800 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
formula.xls
Description: MS-Excel spreadsheet
