Hi, To copy array formula down, you can choose any of the option below:- 1) Move just below the formula cell and press Ctrl + D 2) Use fill down option (Drag the formula down) 3) After entering the formula - by copy paste. press Ctrl + Shift + Enter.
Let me know in case you still have challenges. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, May 10, 2010 at 9:11 AM, <dheerajbank...@punjlloyd.com> wrote: > > Dear Dilip > Thanks for your prompt reply. > The same formula I am trying to put at sr. no. 17 (as per attached file), > it is showing error. Could u please check what is wrong with this. > > > > Regards > > > > *Dilip Pandey <dilipan...@gmail.com>* > Sent by: excel-macros@googlegroups.com > > 05/09/2010 08:07 PM > Please respond to > excel-macros@googlegroups.com > > To > excel-macros@googlegroups.com > cc > dheerajbank...@punjlloyd.com > Subject > Re: $$Excel-Macros$$ Fw: Maximum Date > > > > > Hi Dheeraj, > > Attached file is formulated as per your requiremets. > > Please get back in case of any queries. > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744* > **dilipan...@gmail.com* <dilipan...@gmail.com>* > **dilipan...@yahoo.com* <dilipan...@yahoo.com> > New Delhi - 62, India > > > On 5/9/10, *dheerajbank...@punjlloyd.com* <dheerajbank...@punjlloyd.com><* > dheerajbank...@punjlloyd.com* <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-mac...@googlegroups.com* <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* <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > *http://www.linkedin.com/groups?gid=1871310*<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > *http://www.excel-macros.blogspot.com*<http://www.excel-macros.blogspot.com/> > 4. Learn VBA Macros at > *http://www.quickvba.blogspot.com*<http://www.quickvba.blogspot.com/> > 5. Excel Tips and Tricks at > *http://exceldailytip.blogspot.com*<http://exceldailytip.blogspot.com/> > > To post to this group, send email to > *excel-mac...@googlegroups.com*<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*<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* <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > *http://www.linkedin.com/groups?gid=1871310*<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > *http://www.excel-macros.blogspot.com*<http://www.excel-macros.blogspot.com/> > 4. Learn VBA Macros at > *http://www.quickvba.blogspot.com*<http://www.quickvba.blogspot.com/> > 5. Excel Tips and Tricks at > *http://exceldailytip.blogspot.com*<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*<http://groups.google.com/group/excel-macros/subscribe> > *[attachment "formula by DiLipandey.xls" deleted by Dheeraj > Bankoti/P&E/PLL] * > > > > > > --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > > 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