You are welcome Ashish, I have tested the macro as well and it is working fine.
Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jan 5, 2010 at 12:34 AM, Ashish Sharma <ashish_tech...@yahoo.co.in>wrote: > Hi Dilip, > > Very THANKS for your help, It works perfectly fine. However I used this > macro function for the same function.. > Public Function FindSeries(TRange As Range, MatchWith As String) > ' Application.Calculation = xlCalculationAutomatic > Application.Volatile True > For Each cell In TRange > If cell.Value = MatchWith Then > x = x & cell.Offset(0, 1).Value & ", " > > End If > Next cell > FindSeries = x > End Function > > > Have a great BOOMBASTIC and PROSPEROUS new YEAR to you and other group > members > > Thanks > Ashish > > --- On *Thu, 31/12/09, Dilip Pandey <dilipan...@gmail.com>* wrote: > > > From: Dilip Pandey <dilipan...@gmail.com> > Subject: Re: Taking offset of all the duplicate values - HELP!! > To: "Ashish Sharma" <ashish_tech...@yahoo.co.in> > Cc: jainayus...@gmail.com, excel-macros@googlegroups.com > Date: Thursday, 31 December, 2009, 10:57 PM > > > Just answered this one, let me know if you don't find the respective > email. > > Best Regards n Happy New Year, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com<http://in.mc84.mail.yahoo.com/mc/compose?to=dilipan...@gmail.com> > dilipan...@yahoo.com<http://in.mc84.mail.yahoo.com/mc/compose?to=dilipan...@yahoo.com> > New Delhi - 110062 > > > On 12/29/09, Ashish Sharma > <ashish_tech...@yahoo.co.in<http://in.mc84.mail.yahoo.com/mc/compose?to=ashish_tech...@yahoo.co.in>> > wrote: >> >> >> >> --- On *Tue, 29/12/09, Ashish Sharma >> <ashish_tech...@yahoo.co.in<http://in.mc84.mail.yahoo.com/mc/compose?to=ashish_tech...@yahoo.co.in> >> >* wrote: >> >> >> From: Ashish Sharma >> <ashish_tech...@yahoo.co.in<http://in.mc84.mail.yahoo.com/mc/compose?to=ashish_tech...@yahoo.co.in> >> > >> Subject: Taking offset of all the duplicate values - HELP!! >> To: >> excel-macros@googlegroups.com<http://in.mc84.mail.yahoo.com/mc/compose?to=excel-mac...@googlegroups.com> >> Cc: >> excel-macros@googlegroups.com<http://in.mc84.mail.yahoo.com/mc/compose?to=excel-mac...@googlegroups.com> >> Date: Tuesday, 29 December, 2009, 3:53 AM >> >> Hi Group, >> >> I am working on an Excel calendar where I need to take the offset value >> for all the duplicate values. >> >> I am using the these two functions to get the first two values but if I >> want to have others values what function/formula should I used. ANY HELP >> would be a great help >> >> 1) =MATCH(C9,event_dates,0) >> 2) >> =MATCH(C9,event_dates,0)+MATCH(C9,OFFSET(event_dates,MATCH(C9,event_dates,0),0)) >> >> Now event_dates is a defined named range which consists of DATE values and >> C9 is a criteria which is also a date [i.e 1/1/2009 in below example] >> >> >> Below is some more detail >> date - value >> 1/1/2009 abc >> 1/2/2009 def >> 1/1/2009 zyx >> 1/1/2009 pyq >> >> so I want abc, pyq and zyx for 1/12009 in three cells. I am able to get >> first two but enable to get the third >> >> >> any help from you CHAMPS will be highly appreaciated. >> >> Thanks in advnace. >> Ashish >> >> >> >> ------------------------------ >> The INTERNET now has a personality. YOURS! See your Yahoo! >> Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> >> . >> >> >> ------------------------------ >> The INTERNET now has a personality. YOURS! See your Yahoo! >> Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> >> . > > > > > ------------------------------ > The INTERNET now has a personality. YOURS! See your Yahoo! > Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/>. > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 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
