Dear Sharmaji Nice explanation. I have tweeked my previous formula and that worked. See the attachment.
Regards, DILIPandey On 13 Oct 2011 12:23, "BS" <sharma.aipl....@gmail.com> wrote: > Dilip, > I have attached a file for your reference for what I needed. > > Thank you for your efforts.. > > > -----Original Message----- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: 13-Oct-2011 11:39 AM > To: BS > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Selecting a date from a database, which equal > to or lesser than the selected date > > Oops... apologies. > I was relying only on Match with True check, which used to check less than > values. > > Now, I have used simple Array with Max function to derive the required > result(s). Let me know if this helps. > > Regards, > DILIPandey > > On 10/13/11, BS <sharma.aipl....@gmail.com> wrote: > > Hii Dilip... > > Thank you very much for your work... > > > > This is very close to what I want... but not been perfect.. > > > > Check that when I put 09-Aug-2010 in the cell B3 its showing 01-Jul-10 > > instead of 08-Aug-10 > > > > I want to automatically generate a date from a database, which Is > > equal or preceding to the given criteria. > > > > Thanks & Regards, > > B. Sharma > > > > > > > > > > -----Original Message----- > > From: Dilip Pandey [mailto:dilipan...@gmail.com] > > Sent: 13-Oct-2011 12:54 AM > > To: excel-macros@googlegroups.com > > Cc: sharma....@gmail.com > > Subject: Re: $$Excel-Macros$$ Selecting a date from a database, which > > equal to or lesser than the selected date > > > > Hi, > > > > Use the formula :- > > =OFFSET($A$1,MATCH($B$1,$A$1:$A$6,1)-1,0) > > > > Sample worksheet is also attached for your ready reference. Let me > > know if this suits your requirements. > > > > Regards, > > DILIPandey > > > > On 10/12/11, B Sharma <sharma....@gmail.com> wrote: > >> Dear Excel Experts.... > >> I want to select a date which is either equals to or lesser than the > >> select date. > >> > >> For Example > >> > >> in Column 1 I have different dates > >> > >> 01-Apr-2010 > >> 01-Jul-2010 > >> 15-Aug-2010 > >> 01-Oct-2010 > >> 15-Nov-2010 > >> 08-Aug-2010 > >> > >> (sorted and un sorted both) > >> > >> In Cell B2 I have entered a date, say. 15-Sep-2010 In Cell C3 I want > >> a formula which will return the date either equals to B2 or 1 time > >> lesser than it. > >> In this case the result will be 15-Aug-2010 > >> > >> > >> Please help.... its very urgent > >> > >> -- > >> --------------------------------------------------------------------- > >> - > >> ------------ > >> 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 > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > >> > > > > > > -- > > Thanks & Regards, > > > > DILIP KUMAR PANDEY, mvp > > MBA,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Look_UP_formula_required_for_date_range_and_multiple_criteria by DILIPandey v1.1.xls
Description: MS-Excel spreadsheet
