Hi, In last code given put Y agaist promoter & u will get data for only promoters..
Rgds//Vabs On Friday, September 21, 2012 10:10:50 AM UTC+5:30, amar takale wrote: > > Hi Vabz > I create file with index formula now I want to In Output(2) sheet all > promoter in one shot for all Qtr.I used Data validation for Qtr.But I think > it is not proper Solution. > I want to see Sector wise promotor,FII & so on (From Dec04-Jun05) in one > shot.When I click sector & then Click promoter then show all promotor (From > Dec04-Jun05) & so on.And also same for company wise also.Bcos I have data > from Dec-04 to Jun12 > Bcos ahead I will create Chart On That data.So when I change any filed > then automatic change chart on that data. > Thanks > > On Thu, Sep 20, 2012 at 1:14 PM, amar takale <amart...@gmail.com<javascript:> > > wrote: > >> Hi VabZ >> Currently I am not create sheet But In my mind that type of idea >> generated So I will try it. If I will create this sample file I will send >> it Then you Guide me further activity >> Thanks very much >> >> On Thu, Sep 20, 2012 at 12:54 PM, Vabz <v...@vabs.in <javascript:>>wrote: >> >>> Hi >>> >>> can you share your sample result data in given example in separate sheet. >>> >>> Rgds//Vabs >>> >>> >>> On Thursday, September 20, 2012 12:19:01 PM UTC+5:30, amar takale wrote: >>> >>>> Dear Vabs >>>> I already use auto filter to get data.With auto filter I will get only >>>> One Year Data But I want all Data in one shot >>>> >>>> On Thu, Sep 20, 2012 at 12:06 PM, Vabz <v...@vabs.in> wrote: >>>> >>>>> Hi >>>>> >>>>> Why dont you use filer to get data. >>>>> >>>>> Rgds//Vabs >>>>> >>>>> >>>>> On Thursday, September 20, 2012 11:44:56 AM UTC+5:30, amar takale >>>>> wrote: >>>>> >>>>>> Hi All Champs, >>>>>> Anybody help me regarding tup formula solution. >>>>>> Q: I want to see Sector wise promotor,FII & so on (From Dec04-Jun05) >>>>>> in one shot.When I click sector & then Click promoter then show all >>>>>> promotor (From Dec04-Jun05) & so on.And also same for company wise >>>>>> also.Bcos I have data from Dec-04 to Jun12 >>>>>> >>>>>> Appreciate the help. >>>>>> >>>>>> >>>>>> Let us know in case of any further assistance. >>>>>> >>>>>> >>>>>> Thank you in advance for your help! >>>>>> Amar >>>>>> >>>>>> On Tue, Sep 18, 2012 at 6:21 PM, dguillett1 <dguil...@gmail.com>wrote: >>>>>> >>>>>>> =INDEX(Raw!$B$1:$FC$587,MATCH(****$B5,Raw!$B:$B,0),MATCH($E5,**Raw >>>>>>> **!$3:$3)-6+COLUMN(A$1)) >>>>>>> >>>>>>> Don Guillett >>>>>>> Microsoft Excel Developer >>>>>>> SalesAid Software >>>>>>> dguil...@gmail.com >>>>>>> >>>>>>> *From:* amar takale >>>>>>> *Sent:* Tuesday, September 18, 2012 3:27 AM >>>>>>> *To:* excel-...@googlegroups.com >>>>>>> *Subject:* $$Excel-Macros$$ Required Challenging formula >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Join official facebook page of this forum @ >>>>>>> https://www.facebook.com/**discu**ssexcel<https://www.facebook.com/discussexcel> >>>>>>> >>>>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> >>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>>> in signatures are prohibited. >>>>>>> >>>>>>> 6) Jobs posting is not allowed. >>>>>>> >>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>>>> allowed. >>>>>>> >>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>> Forum owners and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> To unsubscribe from this group, send email to excel-macros...@** >>>>>>> googlegroups.**com. >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Join official facebook page of this forum @ >>>>>>> https://www.facebook.com/**discu**ssexcel<https://www.facebook.com/discussexcel> >>>>>>> >>>>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> >>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>>> in signatures are prohibited. >>>>>>> >>>>>>> 6) Jobs posting is not allowed. >>>>>>> >>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>>>> allowed. >>>>>>> >>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>> Forum owners and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> To unsubscribe from this group, send email to excel-macros...@** >>>>>>> googlegroups.**com. >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>> Join official facebook page of this forum @ https://www.facebook.com/* >>>>> *discussexcel <https://www.facebook.com/discussexcel> >>>>> >>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> 6) Jobs posting is not allowed. >>>>> >>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>> allowed. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>> To unsubscribe from this group, send email to excel-macros...@** >>>>> googlegroups.com. >>>>> >>>>> >>>>> >>>> >>>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To post to this group, send email to excel-...@googlegroups.com<javascript:> >>> . >>> To unsubscribe from this group, send email to >>> excel-macros...@googlegroups.com <javascript:>. >>> >>> >>> >> >> > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
