Hi Dheeraj, Why don't you sort the data with Date column in decending order...
Thanks On Sun, May 9, 2010 at 12:53 AM, <dheerajbank...@punjlloyd.com> wrote: > > 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 > -- ---------------------------------------------------------------------------------- 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