Yes its working ..thanx..i learn more things from this group
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey Sent: Tuesday, March 02, 2010 8:43 PM To: Umesh Matkar Cc: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: month between two different month..formula Dear Umesh, I hope that your query has been answered by Mr. Luka, please revert if you still feel unsolved. -- 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, Mar 1, 2010 at 7:48 PM, Umesh Matkar <matkarum...@gmail.com> wrote: Pls suggest formula ..for below conditions >From To Codes Jul-09 Sep-09 JS0909 Apr-09 Jun-09 AJ0909 Oct-08 Mar-09 OM0809 Apr-08 Sep-08 AS0808 Oct-07 Mar-08 OM0708 Oct-06 Sep-07 OS0607 Sep-06 TS06 (sep-06 and greater than that ..means jan04, aug06 etc) Dear friends...i want to put codes from above table to below tables..if below table date is belong to above table range..than I want to put there code from that particular range. Month codes Jan-06 Apr-06 May-06 Oct-06 Aug-06 Aug-06 Oct-06 Nov-06 Feb-07 Feb-07 Mar-07 Aug-07 Oct-07 Jul-08 Oct-08 Oct-08 Nov-08 Dec-08 Mar-09 Apr-09 Sep-07 Nov-08 May-07 May-02 Jun-04 Oct-04 Thanx Umesh -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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
